Schedule - Nordic PGDay 2025
The Art Of PostgreSQL Configurations: Because Defaults are Boring
Date: 2025-03-18
Time: 09:15–10:05
Room: Main Room
Level: Intermediate
The Purpose and Outline
Effective PostgreSQL configuration is foundational to maximizing resource efficiency, performance, and stability, yet tuning these settings often requires more than simply scaling for performance gains. In this presentation, we’ll explore cornerstone configurations that can make a meaningful impact on PostgreSQL efficiency, focusing on the most crucial settings that DBAs should consider. This session is designed to prompt attendees to think critically about how these configurations interact with their unique environments, rather than offering one-size-fits-all solutions.
Key areas of discussion will include memory management, I/O tuning, checkpoint handling, and autovacuum settings, with a structured approach to analyzing how each influences both on-premises and RDS PostgreSQL deployments. While primarily targeted at OLTP (Online Transaction Processing) environments, the configurations discussed will also touch on aspects relevant to OLAP (Online Analytical Processing) systems, particularly in the areas of memory and I/O management.
Whether you’re managing high-concurrency, transaction-heavy systems or broader PostgreSQL workloads, this presentation aims to provide practical insights for tailoring PostgreSQL configurations to achieve optimal efficiency and stability. Join us to gain a deeper understanding of PostgreSQL’s configuration landscape and to develop strategies for aligning these settings with your specific workload needs.
