timescaledb
A time-series database for high-performance real-time analytics packaged as a Postgres extension
What is timescaledb?
A time-series database for high-performance real-time analytics packaged as a Postgres extension
Overview of timescaledb
What it is
TimescaleDB is a PostgreSQL extension for high-performance real-time analytics on time-series and event data. It is packaged as an extension to PostgreSQL, enabling users to leverage PostgreSQL's ecosystem while gaining specialized time-series capabilities.
Key features
- Automatic partitioning of data into time-based chunks for efficient querying - Columnar storage (columnstore) providing 90%+ compression and faster vectorized queries -
time_bucket()function for time-series aggregation - Continuous aggregates that incrementally refresh materialized views in the background - Skipscan for fast retrieval of the latest reading per sensor (under 100ms) - Direct insert to columnstore via
SET timescaledb.enable_direct_compress_insert = on
Use cases
- IoT sensor data storage and analysis - Real-time analytics on large time-series datasets - Monitoring and observability data - Any application requiring high-performance time-series queries within a PostgreSQL environment
Getting started
Start TimescaleDB locally with one-line install (Linux/Mac): sh curl -sL https://tsdb.co/start-local | sh Or manually with Docker (also for Windows): bash docker run -d --name timescaledb -p 6543:5432 -e POSTGRES_PASSWORD=password timescale/timescaledb-ha:pg18 Connect using psql: bash psql -h localhost -p 6543 -U postgres Create a hypertable with columnstore: sql CREATE TABLE sensor_data ( time TIMESTAMPTZ NOT NULL, sensor_id TEXT NOT NULL, temperature DOUBLE PRECISION, humidity DOUBLE PRECISION, pressure DOUBLE PRECISION ) WITH ( tsdb.hypertable ); Insert sample data and run analytical queries as shown in the repository README.
License and pricing
TimescaleDB is open source. The license is not stated in the provided metadata (NOASSERTION).
Based on the project's public README and repository metadata.