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.
Benchmark PgBouncer against application-side pools at the same client count, size pools from server cores, and know what transaction pooling breaks.
PostgreSQL 14.24 ships on November 12, 2026 as the branch’s final release. What end of life means, which versions to land on, and the pre-flight checks that catch most failed pg_upgrade runs.
EnterpriseDB announced on November 5 that it has acquired Altinity, the main independent provider of enterprise support and managed services for ClickHouse, with integrated enterprise ClickHouse capabilities promised for Q4 2026. You can read the vendor claims yourself in the EDB press release. For a Postgres DBA the M&A is background noise. The useful signal […]
A five-step audit of a handover Postgres cluster: dump every non-default setting from pg_settings, split reload-safe from restart-required, diff two clusters, then converge with ALTER SYSTEM instead of hand-editing the file.
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 […]
The CNCF moved CloudNativePG to Incubating on 2 November 2026. What the review certified, the governance changes that follow, and what it does not mean.