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.

PgBouncer's self-signed TLS setup requires an easy-to-forget CA file parameter—here's what you need to know.

Promoting a secondary and rewinding the old primary with pg_rewind is fast—until a timing bug leaves your new secondary unable to recover.

Google's new checksum verification tool sparked backup integrity concerns, but PostgreSQL's page checksums have been solid since 9.3—some backup tools just…