PostgreSQL Performance and Maintenance
Presented by:
Greg Dostatni
Greg is an experienced IT professional with over 20 years of experience in higher education. Starting as a developer, he worked on software to manage Search and Rescue incidents ans urban crowd movement simulations. He has a background as a DBA / System Administrator working with Oracle and PostgreSQL in Solaris and Linux. Greg has later transitioned into building and managing applications and services for a large university in Canada, including designing developing and managing large shared database environments. Greg is committed to using technology to solve problems both at home and in professional setting.
No video of the event yet, sorry!
Designed for DBAs and DevOps engineers, this training delivers an overview of foundational knowledge for managing PostgreSQL performance and maintenance, delivered as two 3 hour workshops. It includes a guide to assist with evaluating and benchmarking storage options and how specific values relate to database workloads both in cloud and on prem. We conclude with a detailed discussion of many performance critical parameters.
In addition to hardware discussion, we will cover the PostgreSQL architecture related to: Memory configuration and tradeoffs Vacuum parameters and tunning Checkpoint and background writer tunning Timeouts to protect the system from abuse Monitoring, logging and troubleshooting It is important to remember that this training is a condensed session on a topic that typically takes years to master. While we will cover critical areas and provide a broad overview of how specific PostgreSQL components work and how they fit together, our focus is on essentials that will equip you to manage and maintain PostgreSQL effectively.
- Date:
- 2026 March 10 09:00 EDT
- Duration:
- 6 h
- Room:
- Google Meet or Riverside
- Conference:
- PostgresWorld Training 2026
- Language:
- Track:
- Ops
- Difficulty:
- Medium
- Requires Registration:
- Yes (Registered: 0)