TimescaleDB

TimescaleDB is a PostgreSQL extension for high-performance real-time analytics on time-series and event data. It keeps data in PostgreSQL while adding time-series storage and query features for workloads like IoT, financial analysis, and application events.

It automatically partitions data into time-based chunks, supports hypertables, and can write directly to columnstore. It also adds continuous aggregates for incremental refreshes and time_bucket() for time-series aggregation, so queries can scan only the relevant time ranges and columns.

TimescaleDB is built and maintained by TigerData (formerly Timescale) and runs as a self-hosted PostgreSQL extension. A managed option, Tiger Cloud, is also available, while the open source extension can run locally with Docker or be installed on Linux and Mac for development and testing.