pg.Pool vs PgBouncer: When Client-Side Pooling Is Not Enough
PostgreSQL still ships with defaults like `shared_buffers=128MB` and `work_mem=4MB`. This guide covers the 8 settings that actually matter in production, realistic connection limits, PgBouncer, SSD tuning, a production-ready `postgresql.conf` for a 4GB VPS, cache hit ratio SQL, and what tuning will never fix.
May 28, 20266 min read0 reactions0 comments