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/
• Repository: https://github.com/skuznetsov/pg_sorted_heap
• Documentation: https://skuznetsov.github.io/pg_sorted_heap/
• Release notes: https://github.com/skuznetsov/pg_sorted_heap/releases/tag/v0.14.0
• Issues: https://github.com/skuznetsov/pg_sorted_heap/issues