TimescaleDB

TimescaleDB is a time-series database built as an extension on top of PostgreSQL. It gives you the scale of NoSQL time-series with the reliability and tooling of Postgres.

When to Use

• High-Velocity Time-Series on PostgreSQL: Ingesting and querying millions of metrics, IoT sensor data, and financial ticks within PostgreSQL.
• Continuous Aggregations & Materialized Views: Automatically computing real-time 1-minute, hourly, or daily rollups as data arrives.
• Native Columnar Compression: Reducing time-series storage footprints by 90%+ using chunk-level columnar compression.
• Data Retention & Automated Tiering: Automatically dropping or migrating historical time-series data to cold object storage.

Quick Start

-- Convert standard table to hypertable
SELECT create_hypertable('conditions', 'time');