2026-05-04
· 2 min
·
PostgreSQL
Raising autovacuum_max_workers above 3 won't speed up vacuum unless you also increase autovacuum_vacuum_cost_limit—the I/O budget is divided among workers, not…
0 comments
2026-05-04
· 5 min
·
Client Advisories
Unauthenticated attackers can execute arbitrary SQL against pgBouncer 1.25.0 and earlier in specific configurations.
0 comments
2026-05-04
· 7 min
·
PostgreSQL
PostgreSQL 19 finally makes logical replication and physical standbys work together safely.
0 comments
2026-05-03
· 9 min
·
PostgreSQL
PgQue's zero-mutation queue algorithm eliminates the "queue death spiral" by replacing UPDATE-and-DELETE with snapshot diffing.
0 comments
2026-05-03
· 3 min
·
PostgreSQL
Autovacuum_freeze_max_age prevents PostgreSQL's xid wraparound catastrophe.
0 comments
2026-05-02
· 2 min
·
PostgreSQL
Autovacuum's ANALYZE threshold formula combines a fixed floor and a percentage of table size.
0 comments
2026-05-02
· 4 min
·
PostgreSQL
If you have ever run pg_ctl stop -m fast on a primary and watched it hang well past wal_sender_shutdown_timeout, you have met a bug that has been sitting in wal
0 comments
2026-05-01
· 3 min
·
PostgreSQL
Disable autovacuum and PostgreSQL will cheerfully show you every failure mode in its playbook, from table bloat to transaction ID wraparound.
0 comments
2026-05-01
· 6 min
·
PostgreSQL
PostgreSQL 19 is an admin-and-monitoring release with 212 items: worker-managed AIO, smarter planner joins, faster diagnostics, and a C11 requirement.
0 comments
2026-05-01
· 1 min
·
PostgreSQL
PGX is stepping in to maintain pgBackRest as pgxbackup, ensuring critical fixes and PostgreSQL compatibility for the industry-standard backup tool.
0 comments