Hierarchical time-series roll-up pipeline on PostgreSQL/TimescaleDB: continuous aggregates (minute→month), time-weighted LOCF averaging, tiered retention. One-command Docker demo.
-
Updated
Sep 10, 2026 - PLpgSQL
Hierarchical time-series roll-up pipeline on PostgreSQL/TimescaleDB: continuous aggregates (minute→month), time-weighted LOCF averaging, tiered retention. One-command Docker demo.
Time settles into layers. An experimental Rust time-series database with DuckDB SQL, tiered Parquet storage, async S3 WAL/checkpoints, continuous numeric aggregates, and lifecycle scheduling.
Production-grade TimescaleDB patterns — continuous aggregates, retention & compression automation, Python orchestration, and monitoring. Source for www.time-series-data.org.
TimescaleDB / Tiger Data — independent third-party profile of a public API surface, by API Evangelist. TimescaleDB (now part of Tiger Data) is a PostgreSQL-native time-series database featuring hypertables, columnstore (Hypercore), continuous aggregates, retention policies and hyperfunctions.
To associate your repository with the continuous-aggregates topic, visit your repo's landing page and select "manage topics."