TimescaleDB on CloudSonic

Store time-series metrics and sensor data in PostgreSQL with automatic partitioning and native compression

TL;DR TimescaleDB

TimescaleDB is available as a PostgreSQL extension on every CloudSonic managed PostgreSQL instance, adding time-series optimisations for metrics, monitoring, and IoT workloads.

TimescaleDB is an open source time-series database built as a PostgreSQL extension, available on every CloudSonic managed PostgreSQL instance. It adds automatic partitioning of time-series tables, faster time-range queries, and native compression for historical data without breaking compatibility with standard PostgreSQL tooling. TimescaleDB is the recommended choice for applications that store metrics, monitoring data, IoT sensor readings, or any workload where each record has a timestamp and queries typically filter or aggregate by time range.

Prerequisites

TimescaleDB for Time-Series Data on CloudSonic

TimescaleDB on CloudSonic is available as an extension on every managed PostgreSQL instance, enabled on request without any additional configuration or cost. It adds hypertables for automatic time-based partitioning of large datasets, continuous aggregates for pre-computing expensive time-range queries, and native compression for historical data that is no longer being actively updated. TimescaleDB is fully compatible with standard PostgreSQL tooling and the PostgreSQL wire protocol, so existing applications and ORMs that work with PostgreSQL work identically with TimescaleDB without any code changes.