The importance of max_wal_size
Frequent checkpoints kill PostgreSQL performance—here's how to tune max_wal_size to stop them from happening too often.
“Real-World Logical Replication” at Nordic PGDay 2023
Slides from "Real-World Logical Replication" are now live. Dive into practical patterns for PostgreSQL's most powerful replication feature.
“Database Antipatterns, and where to find them” at SCaLE 20x
Discover the database antipatterns that silently sabotage production systems and learn how to spot them before they become costly problems.
Everything you know about setting work_mem is wrong.
Every work_mem tuning formula is wrong—but here's how to find the right number for your workload by analyzing actual temp file spills.
Upcoming Live Presentations
Join the author at three PostgreSQL conferences this spring: SCaLE 20x, Nordic PgDay, and PgDay/MED, covering database antipatterns, logical replication, and…
Workers of the World, Unite!
PostgreSQL's background worker settings are confusing—there are pools within pools.
ALTER TABLE … SET WITHOUT OIDS big gotcha
Dropping a column in PostgreSQL is usually cheap—until you hit ALTER TABLE SET WITHOUT OIDS during pg_upgrade, which rewrites your entire table and can consume…
UUIDs vs serials for keys
UUID vs bigint: they're really two separate choices.
“Database Patterns and How to Find Them” at SCaLE 2023
Discover the database design mistakes that haunt production systems—and how to spot them before they cost you.
“Extreme PostgreSQL” at PgDay/MED
Join us in Malta as we explore PostgreSQL pushed to its limits and beyond.