Issue 647 - Postgres 19's most exciting features by ~postgresweekly

PostgreSQL 19 features I'm excited about | Bytebase

https://www.bytebase.com/blog/postgres-19-features-im-excited-about/

Postgres 19 Features I'm Excited About — An opinionated run-through of some v19 highlights, including pg_plan_advice, DDL extraction functions, online REPACK/REPACK CONCURRENTLY, and observability improvements.

4 months ago

Potential Consequences of Using Postgres as a Job Queue

https://richyen.com/postgres/2026/05/04/postgres_job_queue.html

The Potential Consequences of Using Postgres as a Job Queue — At “small scale” it’s fine, but when do the wheels start to fall off, and what are the alternatives? Richard has some pragmatic pointers.

4 months ago

https://www.figma.com/blog/pgkeeper-building-the-bouncer-we-needed-for-postgres/

How Figma Built the Bouncer It Needed for Postgres — Figma outgrew PgBouncer, evaluated PGCat, and ended up building its own pooler (PGKeeper) with Go and PGX. It’s not public, but they go deep into the design: it exposes gRPC to clients rather than acting as a PG wire-protocol pooler, so each query has metadata to use for priority-based admission control, load shedding & fair sharing.

4 months ago

Two Hundred and Twelve Things

https://thebuild.com/blog/2026/05/01/two-hundred-and-twelve-things/

Two Hundred and Twelve Things — With 212 entries in the draft Postgres 19 release notes being potentially overwhelming, Christophe boiled it down to the “load-bearing” items, while explaining that while v19 has no single "marquee user-facing feature", it’s “exactly what a good database release looks like.”

4 months ago

How are committers selected?

https://vondra.me/posts/how-are-committers-selected/

How Are Postgres Committers Selected? — A Postgres committer explains how people are selected to join this distinguished group.

#postgres #committer #core team #development #process #community

4 months ago

It Depends: Using Session Variables in Postgres

https://www.pgedge.com/blog/it-depends-using-session-variables-in-postgres

It Depends: Using Session Variables in Postgres — You’ve probably used SET to tweak configuration parameters, but did you know you can use it to store your own session variables?

4 months ago

GitHub - rogerwelin/pg_column_tetris: A PostgreSQL extension that can enforce optimal column alignment to minimize row padding waste.

https://github.com/rogerwelin/pg_column_tetris

pg_column_tetris: Enforce Optimal Column Alignment to Minimize Row Padding Waste — Postgres aligns columns to specific byte boundaries for efficiency, inserting ‘padding’ to fill the gaps. This extension can show how many bytes are being lost to padding in existing tables or can warn/block against creating tables with inefficient column ordering.

4 months ago