PgColumnar: A Columnar Database Extension for PostgreSQL 15

PgColumnar is a column-oriented storage extension for PostgreSQL, designed for analytic workloads. It enhances query performance through per-column compression and is ideal for large scans and aggregates. However, traditional row storage remains preferable for high-frequency single-row updates.