· 2 min · PostgreSQL

All Your GUCs in a Row: autovacuum_max_workers

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

· 5 min · Client Advisories

Client Advisory: pgBouncer CVE-2025-12819

Unauthenticated attackers can execute arbitrary SQL against pgBouncer 1.25.0 and earlier in specific configurations.

0 comments

· 7 min · PostgreSQL

Failover Slots, Two Years On

PostgreSQL 19 finally makes logical replication and physical standbys work together safely.

0 comments

· 9 min · PostgreSQL

PgQue: Two Snapshots and a Diff

PgQue's zero-mutation queue algorithm eliminates the "queue death spiral" by replacing UPDATE-and-DELETE with snapshot diffing.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: autovacuum_freeze_max_age

Autovacuum_freeze_max_age prevents PostgreSQL's xid wraparound catastrophe.

0 comments

· 2 min · PostgreSQL

All Your GUCs in a Row: autovacuum_analyze_scale_factor and autovacuum_analyze_threshold

Autovacuum's ANALYZE threshold formula combines a fixed floor and a percentage of table size.

0 comments

· 4 min · PostgreSQL

wal_sender_shutdown_timeout: Now Actually a Timeout

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

· 3 min · PostgreSQL

All Your GUCs in a Row: autovacuum

Disable autovacuum and PostgreSQL will cheerfully show you every failure mode in its playbook, from table bloat to transaction ID wraparound.

0 comments

· 6 min · PostgreSQL

Two Hundred and Twelve Things

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

· 1 min · PostgreSQL

pgxbackup: Continuity Support for pgBackRest

PGX is stepping in to maintain pgBackRest as pgxbackup, ensuring critical fixes and PostgreSQL compatibility for the industry-standard backup tool.

0 comments