Repository navigation
pgColumnar v1.0-dev
Pre-release
Pre-release
pgColumnar v1.0-dev is a pre-release marker for the 1.0 development line
(on-disk format 2.2). It builds from one source tree on PostgreSQL 13 through 19,
and every test suite passes on all seven majors.
Capabilities
- Column-oriented table access method (
USING columnar) with per-column
compression, chunk-group minimum and maximum skipping, per-chunk bloom filters,
and a vectorized scan and aggregate path with late materialization. - Compression codecs
none,pglz,lz4, andzstd. count(*)from catalog metadata, parallel scan, and read stream prefetch on
PostgreSQL 17 and later.- Full index-only scan through a columnar visibility-map fork, on by default.
- Multiple projections (C-Store model): declared column subsets stored sorted,
with a planner projection scan, on by default. - Sorted storage with
columnar.vacuum_sorted. - Arrow and Parquet export and import, flat and nested (one-dimensional arrays
and composite types), self-contained with no libarrow or libparquet dependency.
Documentation
Installation, user guide, administration, configuration, SQL reference,
features, benchmarks, limitations, and testing are under
docs/. The full list of
changes is in
CHANGELOG.md.
Status
This is a pre-release. The VERSION file is the source of truth for the release
marker. PostgreSQL 19 is validated against 19beta2; revalidation against the
final release is pending.