Connection Pooling1 recipe

Efficient database connection pool configs

postgresqlINIadvancedVerified
PostgreSQL Performance Tuning — postgresql.conf

Tuned postgresql.conf settings for a dedicated 8-core / 32 GB RAM database server. Covers shared buffers, WAL, autovacuum, parallel query and connection settings — with explanations for each knob.