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

Поиск
Список
Период
Сортировка
От Informa Tecnologias via PostgreSQL Announce
Тема storage_engine 1.0.7 – columnar + row-compressed Table Access Methods for PostgreSQL 16-18
Дата
Msg-id 177691269033.3558531.11829648896736870095@wrigleys.postgresql.org
обсуждение
Список pgsql-announce
Дерево обсуждения
 

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

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

This email was sent to you from Informa Tecnologias. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to Informa Tecnologias.

You were sent this email as a subscriber of the pgsql-announce mailinglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click the personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 

В списке pgsql-announce по дате отправления:

Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера