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…

Discover what breaks when PostgreSQL scales to its limits, straight from the FOSDEM 2019 talk slides.

Check your sequences for overflow risk without incrementing them. A handy PL/pgSQL function returns all current sequence values at a glance.

Securing PostgreSQL presentation slides from PDXPUG PostgreSQL Day 2018 are now available for download.

PostgreSQL's CHAR type pads with spaces and silently trims them during operations, creating bizarre behaviors that surprise most developers.

LOCK TABLE might seem tempting for serializing access, but it blocks autovacuum and replicates to secondaries. Use advisory locks instead.

Use pg_rewind to reattach a former primary as a secondary without a full rebuild.

PostgreSQL offers three ways to get the current time: now(), statement_timestamp(), and clock_timestamp(). Learn which one to use and when.