Request a Demo
Home   >   mailing lists

ANN: storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18 - Mailing list pgsql-general

From Saulo José Benvenutti
Subject ANN: storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18
Date
Msg-id CAFOk60K4J=Z7V-4jkVTMa4AD+4Yd6vMeUYYV+VS+wvYMuL+COw@mail.gmail.com
Whole thread
List pgsql-general
Tree view

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

Feedback and contributions welcome.

Regards,
Saulo J. Benvenutti
--
       Saulo José Benvenutti
Analista Programador Delphi/C#

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: unique constraint violation on multiple-rows update
Next
From: "David G. Johnston"
Date:
Subject: Re: unique constraint violation on multiple-rows update