Decoding postgresql.conf - which parameters to tweak and when?
Friday, June 26 at 11:00–11:50
-
Divya Sharma has been working with PostgreSQL for 9 years as Solutions Architect and Database Engineer. She has helped several customers migrate to PostgreSQL from commercial database engines. Her day to day role also involves helping customers optimize their PostgreSQL workloads for better performance.
Category: General
Level: Intermediate
Language: EN
Room: 3.010
PostgreSQL has many different parameters divided into in various sub-categories. This talk will cover some of those important parameters in each section, highlighting how to monitor them and when to tune them. Sections and parameters covered in this talk would include :
- Connection and authentication - max_connection, ssl ;
- Resource Utilization (Memory) - shared_buffers, work_mem, maintenance_work_mem, autovacuum_work_mem ;
- Write-Ahead-Log - wal_level, full_page_writes, checkpoint_timoeout, max_wal_size;
- Replication - wal_keep_size, max_slot_wal_keep_size, max_standby_streaming_delay, max_standby_archive_delay, hot_standby_feedback;
- Reporting and Logging - log_min_duration_statement, log_statement;
- Autovacuum - autovacuum_max_workers, autovacuum_freeze_max_age.
We will cover in details the importance of some parameters and how they are connected, interacting with the database resources.
