PostgreSQL 19 lets you repack bloated tables without blocking reads or writes

PostgreSQL 19 Released

PostgreSQL 19 lets you repack bloated tables without blocking reads or writes

PostgreSQL 19 introduces REPACK (CONCURRENTLY), which reclaims table bloat and reorders data to match an index without blocking reads or writes, replacing VACUUM FULL and CLUSTER. The release also adds pg_plan_advice for stabilizing query plans, read-your-writes consistency on standbys via WAIT FOR LSN, INSERT ... ON CONFLICT DO SELECT for get-or-create patterns, and faster foreign key checks that nearly double bulk insert speed.

For over 30 years, the global open source community has built PostgreSQL into a database that organizations trust with their most critical data.
  1. ddxv

    I respect their decision to delay a bit. Looking forward to trying it out.

    Especially this one:

    PostgreSQL 19 adds INSERT ... ON CONFLICT DO SELECT, which lets the RETURNING clause return existing rows that conflict with an insert, simplifying the common "get or create" pattern.

  2. perdy

    The ON CONFLICT DO SELECT looks like a good addition, getting the existing row back from RETURNING. No more second SELECT after DO NOTHING.

  3. vivzkestrel

    - is the data inside postgres stored similar to this? https://www.nan.fyi/database

    - this article talks about key value stores, would relational follow the same method

More from this day

2026-11-19