pg_sorted_heap 0.14.0 released
Posted on 2026-05-18 by Sergey "Computer Mage" Kuznetsov
Related Open Source
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: