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.

PostgreSQL databases live in directories, and naming them wisely saves you headaches during major version upgrades.

Slides from "Why PostgreSQL is Terrible" talk at Nordic PGDay are online. Discover what makes PostgreSQL unexpectedly great through its apparent flaws.

PostgreSQL replication overwhelms with options?

When a network disconnect interrupts your COMMIT, did the transaction really go through?

Streaming replication froze with thousands of locks on non-existent tables.

Database designers often assume every entity needs a primary key. Humans are messier than that.