{"repo":"saulojb/storage_engine","free":true,"listed":false,"github":"https://github.com/saulojb/storage_engine","clone":"git clone https://github.com/saulojb/storage_engine.git","description":"A PostgreSQL extension providing two high-performance Table Access Methods designed for analytical and HTAP workloads — with **significant storage savings and no meaningful query performance penalty** compared to standard heap tables.","language":"C","stars":30,"topics":["columnar-storage","opensource","performance","postgresql","postgresql-extension","table-access-method","deflate","htap","lz4","lz4-compression"],"license":"AGPL-3.0","category":"databases-storage","readme_excerpt":"storage engine v2.4 — TPC-H planner fixes + reread caches + PG15–PG19 validation storage engine v2.4 improves real colcompress performance with narrow planner-hook fixes for official TPC-H queries ( Q7 , Q18 , Q20 , Q21 ) and a targeted replan that avoids bad final nested loops for Q9 -style post-join aggregates on PG16+. It also makes repeated reads measurably cheaper by keeping the colcompress page cache alive across scans in the same backend and by reusing rowcompress metadata/decompressed batches safely across repeated index probes, with observability through engine.rowcompress scan stats() . Validated: 294/294 on PG15, 293/293 on PG16–PG18, 297/297 on PG19 . A PostgreSQL extension providing two high-performance Table Access Methods designed for analytical and HTAP workloads. - colcompress — column-oriented compressed storage with vectorized execution, vectorized GROUP BY aggregation , and parallel scan - rowcompress — row-oriented batch-compressed storage with parallel scan Both AMs coexist alongside standard heap tables in the same database. All catalog objects are isolated in the engine schema, making the extension safe to install alongside citus columnar or any other columnar extension (all exported C symbols carry the se prefix to avoid linker conflicts). Lineage: storage engine is a fork of Hydra Columnar (itself derived from citus columnar), extended with rowcompress , full DELETE/UPDATE support, stripe-level min/max pruning, and a redesigned parallel scan. The Mer","default_branch":null,"files":null,"tree":[],"storefront":"/r/saulojb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/saulojb/storage_engine/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}