| From: | Informa Tecnologias via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
|---|---|
| To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
| Subject: | storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18 |
| Date: | 2026-04-23 02:51:30 |
| Message-ID: | 177691269033.3558531.11829648896736870095@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce |
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
| From | Date | Subject | |
|---|---|---|---|
| Previous Message | EMS Software Development via PostgreSQL Announce | 2026-04-23 02:50:32 | SQL Management Studio for PostgreSQL 2.0 Is Here — Faster, Safer, and More Efficient |