PgBouncer Transaction Pooling: Prepared Statements and Session State
How PgBouncer transaction pooling works, why prepared statements and session state break, how to audit your app, and how to size and monitor pools.
13 min read
Tag
database performance
PostgreSQL Blocking Queries: Find the Root Blocker with pg_locks
Learn to trace PostgreSQL blocking queries to the root blocker with pg_stat_activity, pg_blocking_pids() and pg_locks, then prevent them with lock_timeout.
13 min read
PostgreSQL Index Types: B-Tree, GIN, BRIN and Partial Indexes
Learn how B-Tree, GIN, BRIN and partial indexes work in PostgreSQL, when each fits your data and operators, and how to verify the choice with EXPLAIN.
14 min read
PostgreSQL Connection Pooling: PgBouncer, max_connections and Sizing
Learn why PostgreSQL connections are costly, how app pools and PgBouncer work together, how to size pools, and when transaction-mode pooling breaks your app.
16 min read
Database Connection Pool Sizing for Monoliths Under Heavy Load
Size database connection pools from real database capacity and a global connection budget, tune HikariCP, use PgBouncer, and diagnose connection exhaustion.
14 min read
PostgreSQL Table Partitioning for Time-Series Data and Retention
Learn PostgreSQL range partitioning for time-series tables: pick granularity, verify partition pruning, automate partitions, and drop old data cheaply.
13 min read
PostgreSQL Autovacuum Tuning for Busy Tables: Stop Table Bloat
Learn how dead tuples cause table bloat, how autovacuum triggers, and how to set per-table thresholds and cost limits for high-churn PostgreSQL tables.
13 min read