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#
