PostgreSQL
Connection Pool Sizing: Why More Connections Make It Slower
Past the point where the server can execute work in parallel, adding connections adds queueing rather than throughput — and moves the queue somewhere worse.
· 4 min
category
PostgreSQL
Query planning, indexing, extensions, replication and day-to-day operations on PostgreSQL.
4 articles
PostgreSQL
Transaction Pooling Breaks Only Under Load
Transaction pooling is what makes PgBouncer worth deploying, and it silently removes session state your application may depend on.
· 3 min
PostgreSQL
EXPLAIN, ANALYZE, BUFFERS: Three Different Questions
Which variant you ran decides whether the numbers in front of you are the planner's estimate or a measurement, and whether the pages came from cache.
· 4 min
PostgreSQL
Why an Index Is Not Used: the Estimate, Not the Index
An index the planner ignores is usually a row-estimate problem. The fix starts with what the optimizer expected, not with the index definition.
· 3 min