work_mem: It's a Trap! — With 2 terabytes of RAM and work_mem set to 2MB, you wouldn’t expect your Postgres server to get taken down by the OOM (Out-Of-Memory) killer. Nonetheless, a badly written query did cause that very situation, and two expert Postgres developers uncovered the surprising reason behind it.

Lætitia Avrot and Henrietta Dombrovskaya

SELECT COUNT(*) Shouldn't Take 8 Seconds — Tables grow. Queries slow down. Most teams add a second database. But Postgres can handle it. TimescaleDB adds hypertables, 95% compression, and continuous aggregates. Analytics on live data, same SQL you already write. Start building for free.

Tiger Data (creators of TimescaleDB) sponsor

How Netflix Automated Its RDS Postgres to Aurora Postgres Migration — Back in 2024, Netflix decided to migrate hundreds of Postgres clusters from RDS to Aurora, a challenging task with zero data loss and minimal downtime as must-haves. This is a detailed write-up of the process, and while it was an intra-AWS migration, most of the techniques have universal applicability.

Kannan, Akintayo, Bharadwaj, et al. (Netflix)

We Skipped the OLAP Stack and Built Our Data Warehouse in Postgres — As a Postgres service, Xata wanted to eat its own dogfood, so here’s how they built their own data warehouse approach on top of vanilla Postgres.

Noémi Ványi (Xata)

Waiting for Postgres 19: Add Non-Text Output Formats to pg_dumpall — A deeper look at a welcome Postgres 19 change: “pg_dumpall can now produce output in custom, directory, or tar formats in addition to plain text"..

Hubert 'depesz' Lubaczewski

pg_turret: Stream Structured Postgres Logs to HTTP or Kafka Endpoints — Hooks into Postgres's emit_log_hook to capture events and stream them as structured JSON to HTTP (or Kafka) endpoints in real time without any log file parsing.

lasect

pg_stat_ch: Export Per-Query Postgres Telemetry to ClickHouse — The ClickHouse team built a Postgres extension that captures per-query execution telemetry and exports it to ClickHouse in real-time.

ClickHouse

pg_duckpipe: Real-Time CDC for Your Lakehouse — A new Postgres extension that continuously syncs regular heap tables into DuckLake columnar tables (a Parquet-backed format) via WAL-based CDC.

Relyt