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…

Pgpool2 won't connect after you fix a hostname? Delete the pgpool_status file—it caches host status across restarts and won't update automatically.

Dive into PostgreSQL replication strategies with slides from PerconaLive 2018, covering practical approaches to keeping your databases in sync.

Set wal_level to logical and enable wal_log_hints to unlock logical replication and pg_rewind without restarting your cluster.

Stop guessing what's slow in PostgreSQL—configure logging to actually see it.

Default `archive_mode = off` means `archive_command` is ignored—set both now to avoid a restart later when you need WAL archiving.

Enable wal_compression to shrink write-ahead logs and replica replication traffic after checkpoints. The CPU cost is minimal for nearly all workloads.