ADR-009: Columnar Storage for Historical Analytics¶
Status: Planned
Date: 2026-01-24
Context¶
Standard row-based PostgreSQL queries for 10-year price trends may slow down as data grows > 5M records.
Decision¶
Deferred: DuckDB or Citus Columnar Extension.
Rationale¶
- Scale: Columnar storage is 10-100x faster for aggregate analysis (Year-over-Year trends).
- Low Friction: Start with row-based storage and migrate only when query performance drops.