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

Feedback and contributions welcome.

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