“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.
Xtreme PostgreSQL!
Slides from the February 2023 SFPUG talk are now available—grab them to dive into what was discussed.
Nordic PgDay 2023
Logical replication in PostgreSQL can seem straightforward in theory but presents real challenges in production.