Proper PostgreSQL Parameters to Prevent Poor Performance

#### Presented by Greg Dostatni and Amanda Nystrom

RSVP Here.

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.