Tutorials › PostgreSQL Essentials › TimescaleDB for Time-Series

TimescaleDB for Time-Series

7 min read

TimescaleDB extends PostgreSQL for time-series data with hypertables that auto-partition by time. Use time_bucket() for interval aggregation. It handles millions of inserts per second with excellent compression.

TimescaleDB Extension

TimescaleDB turns PostgreSQL into a powerful time-series database.

CREATE EXTENSION timescaledb;

CREATE TABLE metrics (
  time   TIMESTAMPTZ NOT NULL,
  device TEXT,
  temp   DOUBLE PRECISION
);

SELECT create_hypertable('metrics', 'time');

-- Auto-bucketing
SELECT time_bucket('1 hour', time) AS hour,
       AVG(temp)
FROM metrics GROUP BY 1 ORDER BY 1;

← PostgreSQL Security Hardening 🏁 Finish tutorial →

Quick Access

TimescaleDB for Time-Series

TimescaleDB Extension