Upcoming presentations
No upcoming presentations...
Past presentations
- monitoring & "Monthly DB Reports"
- backup / recovery
- replication & HA
- DR sites and connection pooling
- Capacity planning & metrics
- Scaling
- Ongoing Architecture Monitoring & Lifecycle
Backup & recovery automation
The DB assessment
Defining capacity and scaling points
Scaling options
The Data Architecture Lifecycle
We'll discuss architecture and scaling to include:
This presentation will address Enterprise Data Architecture methods and components with PostgreSQL based on our experience in the trenches. Topics include:
Monitoring automation
A walk through of monitoring PostgreSQL database clusters to include: Relevant PostgreSQL system catalog metrics Relevant contribs / extensions PostgreSQL log parsers PostgreSQL performance troubleshooting Performance tuning methods We'll discuss important segments to monitor such as: - buffer pool usage and sizing - checkpoints & the bgwriter - table stats such as sequential scans, and hit rat...