· 2 min · PostgreSQL

All Your GUCs in a Row: autovacuum_vacuum_max_threshold

PostgreSQL 18 finally fixes the autovacuum formula that left billion-row tables waiting for 200M dead tuples.

0 comments

· 12 min · PostgreSQL

A Field Guide to Alternative Storage Engines for PostgreSQL

Six years after PostgreSQL shipped the table access method API, the alternative storage engine ecosystem is thriving—but messier than early predictions…

0 comments

· 9 min · PostgreSQL

pg_lake vs Lakebase: Two Very Different Things Called “Postgres + Lakehouse”

Snowflake's pg_lake and Databricks' Lakebase both wrap PostgreSQL for lakehouse workloads, but they're nearly opposite architectures.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: autovacuum_vacuum_insert_scale_factor and autovacuum_vacuum_insert_threshold

PostgreSQL 13 added insert-triggered autovacuum to solve a critical problem: append-only tables never vacuumed, breaking index-only scans and delaying tuple…

0 comments

· 7 min · FOSSLaw, PostgreSQL

The Maintainer Is Not the Owner

When a maintainer rewrites a project with AI and changes its license, they've crossed a line.

0 comments

· 8 min · PostgreSQL

Eight Bytes Is the Easy Part

PostgreSQL 19 expands MultiXactOffset to 64 bits, eliminating a real outage failure mode. So when do regular transaction IDs get the same treatment?

0 comments

· 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