Getting started with TimescaleDB

TimescaleDB is an extension of PostgreSQL (it uses PostgreSQL as its underlying database engine) adding additional features specifically for handling time-series data. As such, the integration of TimescaleDB in the DBOD service should be seen as providing an enhancement to the existing PostgreSQL offering, rather than an entirely new database type.

TimescaleDB extends PostgreSQL with functionalities like hypertables, continuous aggregates, and more efficient storage mechanisms for time-series data. While PostgreSQL itself can handle time-series data, TimescaleDB provides performance optimizations and ease-of-use features specifically for these types of workloads, making it similar in use cases to InfluxDB.

TimescaleDB Community Edition is now available in our PostgreSQL 14 and 15 releases. As described in our PG extensions documentation, if you want to use TimescaleDB, please open us a SNOW ticket mentioning in which instance, database, and schema (if not the default one) you need it installed. We will install and enable it for you, as superuser privileges are required.

Please refer to the Timescale Docs for latest documentation and tutorials.