Tuning PostgreSQL to work even better
summary
Covers the 13 practical Postgres knobs to change and how to inspect them with pg_settings and SHOW, including shared_buffers (suggest 25–40% of RAM), work_mem (examples: default 4MB, try 10MB for heavy sorts but watch concurrent usage), maintenance_work_mem (~5% RAM), max_connections (default 100), idle_in_transaction_session_timeout (e.g. 30m), checkpoint_timeout (10–30m), max_wal_size (default 1GB), wal_buffers (~32MB), effective_cache_size (~50% RAM), random_page_cost (~1.1 for SSDs), plus logging flags and diagnostics; leave autovacuum and fsync enabled.
AI-written summary · about
chapters (9)
- 0:00Introduction and config levels
- 4:22Parameter contexts
- 6:36Finding parameter info
- 7:35Configuration files
- 8:24Checking current values
- 8:34Source of settings
- 8:44Connection parameters
- 9:42Memory and WAL tuning
- 30:49Summary of key parameters
related talks
34mTuning PostgreSQL to work even better
45mProper PostgreSQL Parameters to Prevent Poor Performance
52mPostgreSQL Configuration for Humans
43mPostgres Performance: From Slow to Pro
57mPostgreSQL When It's Not Your Job
48mPractical Memory Tuning for PostgreSQL
25mScaling PostgreSQL Beyond Query Optimization
18mTuning Parameters in Postgres vs. Tuning Your Queries