Request a Demo
Home   >   mailing lists

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

From Informa Tecnologias via PostgreSQL Announce
Subject storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18
Date
Msg-id 177691269033.3558531.11829648896736870095@wrigleys.postgresql.org
Whole thread
List pgsql-announce
Tree view
 

storage_engine 1.0.7 – 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 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-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 their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to Informa Tecnologias.

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

pgsql-announce by date:

Previous
From: EMS Software Development via PostgreSQL Announce
Date:
Subject: SQL Management Studio for PostgreSQL 2.0 Is Here — Faster, Safer, and More Efficient