public inbox for pgsql-announce@postgresql.org  

help / color / mirror / Atom feed

From: Informa Tecnologias via PostgreSQL Announce <announce-noreply@postgresql.org>
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
Subject: storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18
Date: Thu, 23 Apr 2026 02:51:30 +0000
Message-ID: <177691269033.3558531.11829648896736870095@wrigleys.postgresql.org> (raw)

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–5x smaller
 - GIN/JSONB queries: fully supported

Compatible with PostgreSQL 16, 17, and 18.

GitHub:  https://github.com/saulojb/storage_engine  
PGXN:    https://pgxn.org/dist/storage_engine/  
Article: https://dev.to/saulojb/storageengine-two-high-performance-table-access-methods-for-postgresql-analyt...

Feedback and contributions welcome.

Regards,
Saulo J. Benvenutti

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-announce@postgresql.org
  Cc: announce-noreply@postgresql.org, pgsql-announce@lists.postgresql.org
  Subject: Re: storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18
  In-Reply-To: <177691269033.3558531.11829648896736870095@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox