Slides from the February 2023 SFPUG talk are now available—grab them to dive into what was discussed.

Logical replication in PostgreSQL can seem straightforward in theory but presents real challenges in production.

Popular streamers and millions of concurrent viewers expose a PostgreSQL anti-pattern: bulk inserts on foreign keys trigger MultiXact overflow and brutal lock…

Schema changes on busy tables can deadlock your system. Use LOCK TABLE NOWAIT in a retry loop to avoid blocking the queue behind your ALTER TABLE.

NUMERIC is 2–5x slower than DOUBLE PRECISION in arithmetic operations, but not absurdly so.

Have a PostgreSQL story to share? PgDay 2020's Call for Proposals welcomes first-time speakers and fresh perspectives from the community.

The inaugural PgDay San Francisco lands January 21 at the Swedish-American Hall. Call for proposals and early-bird tickets are now open.

Slides from my PGDay Nordic 2019 talk on lookups are now online—dive into the techniques that made the presentation.

PostgreSQL lets you export transaction snapshots so multiple sessions see the exact same database view—essential for tools like parallel pg_dump that need…

PostgreSQL's autovacuum freeze parameters prevent catastrophic transaction ID wraparound—and cranking them up is a mistake that can force your database…