PostgreSQL only listens on one port, but you can use pgbouncer or stunnel to accept TLS connections on a second port and route them to your server.

Learn the architecture and skills you need to build a PostgreSQL foreign data wrapper that reads from external data sources.

Higher max_wal_size means faster checkpoints but slower crash recovery. Here's how to balance the tradeoff based on what matters most to your system.

Frequent checkpoints kill PostgreSQL performance—here's how to tune max_wal_size to stop them from happening too often.

Slides from "Real-World Logical Replication" are now live. Dive into practical patterns for PostgreSQL's most powerful replication feature.

Discover the database antipatterns that silently sabotage production systems and learn how to spot them before they become costly problems.

Every work_mem tuning formula is wrong—but here's how to find the right number for your workload by analyzing actual temp file spills.

Join the author at three PostgreSQL conferences this spring: SCaLE 20x, Nordic PgDay, and PgDay/MED, covering database antipatterns, logical replication, and…

PostgreSQL's background worker settings are confusing—there are pools within pools.

Dropping a column in PostgreSQL is usually cheap—until you hit ALTER TABLE SET WITHOUT OIDS during pg_upgrade, which rewrites your entire table and can consume…