· 3 min · PostgreSQL

All Your GUCs in a Row: autovacuum_naptime, autovacuum_vacuum_cost_delay, autovacuum_vacuum_cost_limit

Autovacuum's three key parameters work together to control when it runs, how hard, and how it throttles itself.

0 comments

· 2 min · PostgreSQL

Christophe’s Seven Rules of Disaster Reponse

Train driver pointing When your database catches fire, panic is optional. Learn seven battle-tested rules that turn chaos into a coordinated response.

0 comments

· 4 min · PostgreSQL

MultiXact Members at 64 Bits: One Less Wraparound to Worry About

PostgreSQL 19 eliminates the 32-bit MultiXactOffset ceiling that has crashed high-concurrency FK-heavy clusters at 3 a.m.

0 comments

· 5 min · PostgreSQL

What a Data Lake Actually Is (and why you probably don’t need one)

Most organizations that build data lakes don't need them.

0 comments

· 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