Ross ROSS = Recommend OSS · open-source software intelligence for agents

citusdata/cstore_fdw

Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized columnar storage implementation built as a table access method. observed · 2026-08-28

github.com/citusdata/cstore_fdw · C · Apache-2.0 (permissive) observed · 2026-08-28

Health v2 · maintenance only

23/100

  • Activity 0
  • Release rhythm 8
  • Longevity 100
How is this computed?

round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.

  • gap_med: n/a
  • age_days: 4535
  • days_rel: n/a
  • days_push: 2004
  • n_releases_24m: 0

Full methodology

Adoption not part of the score

1783 stars · 169 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

cstore_fdw is a PostgreSQL extension implementing a columnar store as a foreign data wrapper, inspired by the ORC format, designed for analytics workloads with batch loading. It is now superseded by the columnar table access method built into the Citus extension.

Use cases

  • store analytics tables in a columnar format in postgres
  • compress large postgres tables 6x-10x for archival
  • speed up analytical queries by reading only relevant columns
  • batch-load event or log data into postgres for reporting
  • reduce storage footprint of wide postgres tables

When to choose

  • you are on an older PostgreSQL version without the Citus columnar access method
  • you need an ORC-inspired columnar format via foreign data wrapper
  • you want proven 6x-10x compression for archival data

When to avoid

  • starting a new project - use Citus columnar instead
  • you need streaming replication or easy pg_upgrade with columnar tables
  • you need frequent single-row updates or deletes

Facets

library · maturity maintenance

database compression databases analytics big-data self-hosted postgresql-extension columnar-storage foreign-data-wrapper orc-format analytics deprecated linux macos

1 source

Member repositories

RepositoryRoleHealth v2
citusdata/cstore_fdwmain23

For agents

markdown · JSON · MCP: product_card(name="citusdata/cstore_fdw")

Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem