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 1wFkAm-005Ux4-1h for pgsql-announce@arkaria.postgresql.org; Thu, 23 Apr 2026 02:52:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wFkAl-00GKVf-0d for pgsql-announce@arkaria.postgresql.org; Thu, 23 Apr 2026 02:52:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wFkAk-00GKVQ-1M for pgsql-announce@lists.postgresql.org; Thu, 23 Apr 2026 02:52:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wFkAh-00000002ZhV-2vb4 for pgsql-announce@lists.postgresql.org; Thu, 23 Apr 2026 02:52:10 +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=JfJhems7Ka5P5HexgsewKAdgBMj3VSNFZ0yIYp8M9KY=; b=onnfL/MRRKQTjNdF77swEKupRP qZdGs5z2keWV2IeCG6s/3BlMqYbfodUvNKqUUKzmhbTO089pR76774BLnpz4CNNp1CFrBIY9zt/UO JLADIKKaddirX9c6+MKL23VlUI7khQ6zJ/GeqtbmK5LXatgGE1jWUKya3mIWIj6VXTN7YQA6N1jcm paGgFsBBmD3WCpzXZ/TSuTcQ52dnzfHdxLYQ1HvAmuFfbek+zTuObAkB+i2SVpzPDG3uIRPzcwGBd NnNMMhO3SmMq4SE79tiY49SsVr69CFkACK7sIoN04useC88wpuNR8sspi3//jTA+bqaIQV6inpzuT 7Lb0DHlg==; 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 1wFkAe-0077XF-0O for pgsql-announce@lists.postgresql.org; Thu, 23 Apr 2026 02:52:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wFkAc-00FZWY-32 for pgsql-announce@lists.postgresql.org; Thu, 23 Apr 2026 02:52:03 +0000 Content-Type: multipart/alternative; boundary="===============4555964327119276667==" MIME-Version: 1.0 Subject: =?utf-8?q?storage=5Fengine_1=2E0=2E7_=E2=80=93_columnar_+_row-compressed_Table_Access_Methods_for_PostgreSQL_16-18?= To: PostgreSQL Announce From: Informa Tecnologias via PostgreSQL Announce Reply-To: saulojb@gmail.com Date: Thu, 23 Apr 2026 02:51:30 +0000 Message-ID: <177691269033.3558531.11829648896736870095@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: ce3b0c5b87ab162adbe459b9bab4d8628489ce681d37ce538433c57711cea902 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4555964327119276667== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Hi, I'd like to announce storage_engine 1.0.7, a PostgreSQL extension providing two high-performance Table Access Methods: - colcompress: column-oriented compressed storage with vectorized execution, chunk-level min/max pruning, parallel scan, and MergeTree-like ordering. - rowcompress: row-oriented batch-compressed storage with parallel scan, DELETE/UPDATE support via deleted bitmasks, and LRU decompression cache. Highlights vs heap (1M rows, PostgreSQL 18, serial): - Aggregations: up to 10x faster - Compressed size: 3=E2=80=935x smaller - GIN/JSONB queries: fully supported Compatible with PostgreSQL 16, 17, and 18. GitHub: https://github.com/saulojb/storage_engine =20 PGXN: https://pgxn.org/dist/storage_engine/ =20 Article: https://dev.to/saulojb/storageengine-two-high-performance-table-ac= cess-methods-for-postgresql-analytics-and-htap-4hgp Feedback and contributions welcome. Regards, Saulo J. Benvenutti --===============4555964327119276667== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable storage_engine 1.0.7 =E2=80=93 columnar + row-compressed Table A= ccess Methods for PostgreSQL 16-18
 

storage_engine 1.0.7 =E2=80=93 columnar + row-compressed Table Access= Methods for PostgreSQL 16-18

Hi,

I'd like to announce storage_engine 1.0.7, = a PostgreSQL extension providing two high-performance Table Access Methods:

  • colcompress: column-oriented compressed sto= rage with vectorized execution, chunk-level min/max pruning, parallel scan, and MergeTree-like ordering.

  • rowcompress: row-oriented batch-compressed = storage with parallel scan, DELETE/UPDATE support via deleted bitmasks, and LRU decompression cache.

Highlights vs heap (1M rows, PostgreSQL 18,= serial):

  • Aggregations: u= p to 10x faster
  • Compressed size= : 3=E2=80=935x smaller
  • GIN/JSONB queri= es: fully supported

Compatible with PostgreSQL 16, 17, and 18.<= /p>

GitHub: https://github.com/saulojb/storage= _engine
PGXN: https://pgxn.org/dist/storage_engine/
Article: https://dev.to/saulojb/storageengine-two-high-performance-table-ac= cess-methods-for-postgresql-analytics-and-htap-4hgp

Feedback and contributions welcome.

Regards, Saulo J. Benvenutti
This email was sent to you from Informa Tecnologias. It was delivered on th= eir behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Informa Tecnologias.

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/.
 
--===============4555964327119276667==--