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)
