Time-series database

TimescaleDB

Time-series and real-time analytics on PostgreSQL.

A PostgreSQL extension that partitions tables into time-based chunks (hypertables) and adds columnar compression, continuous aggregates and time-series functions, while keeping full SQL and the Postgres ecosystem.

Data model: Time-series
Vendor: Tiger Data (formerly Timescale)
License: Apache 2.0 core + Timescale License
Articles: 1

TimescaleDBIntermediate

Why is my TimescaleDB continuous aggregate missing the latest data?

Since TimescaleDB 2.13 continuous aggregates are materialized-only by default. Refresh policies, real-time aggregation and backfilling explained.

#maintenance#performance#troubleshooting

Tanishk · 7 min

Nov 2, 2026