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