Decoding postgresql.conf - which parameters to tweak and when?
Tuesday, September 08 at 11:10–12:00
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.
