pg_sorted_heap 0.14.0 released

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)