← Graph

Columnar Storage

concept 3 connections

Alternative on-disk storage layout where each column is stored together rather than each row. Typical for analytical/BI workloads: queries touching many rows but few columns are dramatically faster. Because every value in a column has the same type, columnar data compresses well — often ~10× (e.g. 40 TB → 4 TB, fitting on NVMe). Downside: can't really update rows — append-only. Citus exposes this in Postgres via `USING columnar`, and columnar and row tables can be mixed in a single query (cold partitions columnar, newest partition row-based).

category
architecture
about
Columnar Storage concept
Explains columnar storage via Citus for analytical workloads.
tool ClickHouse
related_to
Columnar Storage concept
ClickHouse is a columnar database.
tool Citus
related_to
Columnar Storage concept
Citus provides columnar storage in Postgres via USING columnar.

Provenance

Read by
2 extractions