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!
Getting core parameters right is essential for ensuring good performance and stability from your PostgreSQL database. As PostgreSQL is now approaching 400 parameters that can be set in addition to OS, kernel and disk options, configuring a PostgreSQL database can be a daunting task. In this beginner friendly session, we will focus on some key parameters and discuss the trade-offs between them.
You’ll learn how to adjust these parameters and how to decide the correct values for your specific hardware and workload. We will cover critical parameters related to memory management, disk usage, and parallelism for both Linux and Windows machines.
By the end of this talk, you’ll have a clear understanding of the foundational settings that can make or break PostgreSQL performance and how to adjust them to your needs and hardware. This session is designed for those who are just starting their journey with PostgreSQL performance tuning and want to build a strong foundation.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Essentials
- Difficulty:
- Easy