pgsql-announce
❮
storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18
- Jump to comment-1Informa Tecnologias via PostgreSQL Announce<announce-noreply@postgresql.org>Apr 23, 2026, 2:52 AM UTCHi,
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
- rowcompress: row-oriented batch-compressed storage with parallelexecution, chunk-level min/max pruning, parallel scan, and MergeTree-like ordering.
Highlights vs heap (1M rows, PostgreSQL 18, serial):scan, DELETE/UPDATE support via deleted bitmasks, and LRU decompression cache.
- 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