public inbox for pgsql-announce@postgresql.org  

help / color / mirror / Atom feed
From: Sergey "Computer Mage" Kuznetsov via PostgreSQL Announce <announce-noreply@postgresql.org>
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
Subject: pg_sorted_heap 0.14.0 released
Date: Mon, 18 May 2026 20:12:40 +0000
Message-ID: <177913516055.803.10890499456720421868@wrigleys.postgresql.org> (raw)

I am pleased to announce pg_sorted_heap 0.14.0, a PostgreSQL extension for physically sorted heap storage, zone-map pruning, planner-integrated vector search, and PostgreSQL-native GraphRAG experiments.

This release is verified on PostgreSQL 16, 17, and 18. It is also now available on PGXN.

Highlights:

- PostgreSQL 16 is now part of the verified support matrix, alongside PostgreSQL 17 and 18.
- pg_upgrade 16->18 and 17->18 are covered by release gates.
- Native PostgreSQL partitioned parents have explicit sorted-heap maintenance helpers and partition-aware vector search helper paths.
- sorted_hnsw is planner-visible through the Index AM path for covered KNN shapes, including parent Merge Append over leaf HNSW indexes.
- clustered_pk_index accepts one or two integer key columns for directed-placement workloads.
- Composite zone-map metadata tracks first-key block ranges plus a bounded second-key summary where safe.
- sorted_heap_bulk_load_ordered(...) adds trusted ordered ingestion with fail-closed observational append-run witness metadata.
- GraphRAG release gates cover lifecycle, dump/restore, crash recovery, and concurrent online maintenance with KNN and GraphRAG readers.

The stable release surface is intentionally bounded: sorted_heap storage and maintenance, zone-map pruning, svec/hsvec, sorted_hnsw, and the documented GraphRAG wrapper/dispatcher APIs. FlashHadamard, TurboQuant, and large-vector sketches remain experimental research and benchmark lanes.

Installation:

    CREATE EXTENSION pg_sorted_heap;

Upgrade:

    ALTER EXTENSION pg_sorted_heap UPDATE TO '0.14.0';

Links:

- PGXN: [https://pgxn.org/dist/pg_sorted_heap/0.14.0/](https://pgxn.org/dist/pg_sorted_heap/0.14.0/) 
- Repository: [https://github.com/skuznetsov/pg_sorted_heap](https://github.com/skuznetsov/pg_sorted_heap)
- Documentation: [https://skuznetsov.github.io/pg_sorted_heap/](https://skuznetsov.github.io/pg_sorted_heap/)
- Release notes: [https://github.com/skuznetsov/pg_sorted_heap/releases/tag/v0.14.0](https://github.com/skuznetsov/pg_sorted_heap/releases/tag/v0.14.0)
- Issues: [https://github.com/skuznetsov/pg_sorted_heap/issues](https://github.com/skuznetsov/pg_sorted_heap/issues)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-announce@postgresql.org
  Cc: announce-noreply@postgresql.org, pgsql-announce@lists.postgresql.org
  Subject: Re: pg_sorted_heap 0.14.0 released
  In-Reply-To: <177913516055.803.10890499456720421868@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox