Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wP4Kt-000O3y-2W for pgsql-announce@arkaria.postgresql.org; Mon, 18 May 2026 20:13:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wP4Kr-00348p-2Z for pgsql-announce@arkaria.postgresql.org; Mon, 18 May 2026 20:13:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wP4Kq-00347q-1I for pgsql-announce@lists.postgresql.org; Mon, 18 May 2026 20:13:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wP4Km-00000000Doa-30ZD for pgsql-announce@lists.postgresql.org; Mon, 18 May 2026 20:13:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=sFVCFAO5sl3OkZEI0AAorA/dMC1UhEhuuiPt045HbQo=; b=xbdQIQzaLTF1ncVP82EYHCeA39 tPvOwhzeogkcjoZYmvErPTLgeTUbG6ofMHUn1uLzOioqDJWdujfYETouzBnsngKfvSbRJoh7G+gxe gBOIJo15IorRzXIGvPivWREpcHNRtJhtycY7PaqJ9cfd3PkoW63SfqP9Mao1eulTSug9ft/TmKuF9 1wfqDuNmj1IFfYkRK7mdCtSOOD7yWu4fSwkaXy8bjWbIuAxMuhdo7iqRvXSPO3kElnEsEc4rBPmS4 cnLb8Q4cQorRdPbjQ37yUWQDlClUaaiorHap66U+Eb3iWHn6IaTCltZCUTj11SGV9VVfFnwksr/t7 IaqPTAhw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wP4Kl-000eQi-1t for pgsql-announce@lists.postgresql.org; Mon, 18 May 2026 20:13:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wP4Kl-001H4N-1Q for pgsql-announce@lists.postgresql.org; Mon, 18 May 2026 20:13:03 +0000 Content-Type: multipart/alternative; boundary="===============5005907562754869644==" MIME-Version: 1.0 Subject: pg_sorted_heap 0.14.0 released To: PostgreSQL Announce From: "Sergey \"Computer Mage\" Kuznetsov via PostgreSQL Announce" Reply-To: github@iterudit.com Date: Mon, 18 May 2026 20:12:40 +0000 Message-ID: <177913516055.803.10890499456720421868@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: ff42f83f34b79b7ebfccd8b517d54bf5f6ed8c550985a658af624e09521ce40a List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5005907562754869644== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable 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 avail= able on PGXN. Highlights: - PostgreSQL 16 is now part of the verified support matrix, alongside Postg= reSQL 17 and 18. - pg_upgrade 16->18 and 17->18 are covered by release gates. - Native PostgreSQL partitioned parents have explicit sorted-heap maintenan= ce 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-pl= acement 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 fa= il-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 an= d maintenance, zone-map pruning, svec/hsvec, sorted_hnsw, and the documente= d GraphRAG wrapper/dispatcher APIs. FlashHadamard, TurboQuant, and large-ve= ctor 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/dis= t/pg_sorted_heap/0.14.0/)=20 - Repository: [https://github.com/skuznetsov/pg_sorted_heap](https://github= .com/skuznetsov/pg_sorted_heap) - Documentation: [https://skuznetsov.github.io/pg_sorted_heap/](https://sku= znetsov.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://git= hub.com/skuznetsov/pg_sorted_heap/issues) --===============5005907562754869644== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pg_sorted_heap 0.14.0 released
 

pg_sorted_heap 0.14.0 released

I am pleased to announce pg_sorted_heap 0.1= 4.0, a PostgreSQL extension for physically sorted heap storage, zone-map pr= uning, planner-integrated vector search, and PostgreSQL-native GraphRAG exp= eriments.

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

Highlights:

  • PostgreSQL 16 i= s now part of the verified support matrix, alongside PostgreSQL 17 and 18.<= /li>
  • pg_upgrade 16-&= gt;18 and 17->18 are covered by release gates.
  • Native PostgreS= QL partitioned parents have explicit sorted-heap maintenance helpers and pa= rtition-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_in= dex 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 summar= y where safe.
  • sorted_heap_bul= k_load_ordered(...) adds trusted ordered ingestion with fail-closed observa= tional append-run witness metadata.
  • GraphRAG releas= e gates cover lifecycle, dump/restore, crash recovery, and concurrent onlin= e 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. FlashHa= damard, 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:
This email was sent to you from Sergey "Computer Mage" Kuznetsov.= It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Sergey "Computer Mage" Kuznetsov.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============5005907562754869644==--