· 4 min · PostgreSQL

All Your GUCs in a Row: autovacuum_multixact_freeze_max_age

PostgreSQL's MultiXact ID space wraps like transaction IDs, and this parameter forces anti-wraparound vacuums before it does.

0 comments

· 17 min · PostgreSQL

Managed Postgres, Examined: Amazon Aurora PostgreSQL

A photorealistic image of an elephant that is all the shades of the aurora borealis, standing in a nordic landscape. Aurora PostgreSQL separates compute from a distributed storage layer that's radically unlike stock PostgreSQL.

0 comments

· 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