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.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/timescaletimescaledb.svg)](https://yunodb.com/tools/timescaletimescaledb?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/timescaletimescaledb?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/timescaletimescaledb.svg" alt="Featured on YunoDB" height="20"></a>