postgres.email
❮

ANN: storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18

  • Jump to comment-1
    Saulo José Benvenutti<saulojb@gmail.com>
    Apr 19, 2026, 1:46 PM UTC
    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#
    View in PostgreSQL Archives →