PgBouncer vs App-Side Pools: Benchmark Postgres Connections
Benchmark PgBouncer against application-side pools at the same client count, size pools from server cores, and know what transaction pooling breaks.
Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
Posts on configuration tuning (memory, WAL, autovacuum), indexing strategies, and query optimization.
Before/after case studies showing how specific changes affected latency, throughput, or cost.
Benchmark PgBouncer against application-side pools at the same client count, size pools from server cores, and know what transaction pooling breaks.
Every few months a team pings me with the same story: insert throughput on one table quietly collapsed. Same hardware, same queries, the only thing that changed is row count. Nine times out of ten the table has a uuid primary key defaulting to gen_random_uuid(), and the index has turned into a pile of half-filled […]
HypoPG 1.4.4 lets you test Postgres index ideas in a plain EXPLAIN before paying the write cost. What changed, the workflow, and where the extension lies to you.
pg_hint_plan 1.9.0 is the first release built on PostgreSQL 19’s path generation strategies. How to inventory your hints, test hinted versus unhinted plans, and delete the ones that no longer earn their keep.
Postgres runs out of connections long before it runs out of CPU. The classic shape: an application fleet scales from 12 pods to 60 for a morning peak, each pod holding a 10-connection pool, and an instance comfortable at 120 backends is suddenly carrying 600. No query got worse; everything got slower. Every backend is […]
If your Postgres dashboard runs REFRESH MATERIALIZED VIEW on a schedule, you know the ritual: for a few seconds, readers queue behind a lock while the database recomputes a result it mostly already had. The fix is not a faster refresh. It is not refreshing at all. pg_ivm — the Incremental View Maintenance extension — […]
PgBouncer 1.26.0 fixes three pre-auth DoS CVEs and adds per-database query_wait_timeout plus pool_idle_timeout. Here is how to tune both for tail latency.
pg_stat_statements evicts least-executed statements, splits or merges queryids by parse tree, hides nested work, and has no application_name column. A DBA triage guide for Postgres 17, 18, and 19.
PostgreSQL 18’s B-tree skip scan lets multicolumn indexes serve queries that omit the leading column. Here’s how to read the plan, when it wins, and when it backfires.
Dead tuples are invisible—until they aren’t. On write-heavy workloads—order and status tables, event streams, telemetry from Houston’s energy corridor—every UPDATE and DELETE leaves an old row version behind. PostgreSQL’s MVCC design is why readers never block writers, but the tradeoff is that stale row versions accumulate until autovacuum sweeps them away. When autovacuum falls behind, […]