TimescaleDB is a PostgreSQL extension for the support of time series data. This extension adds several features and functions. You can find more information on the official documentation. TimescaleDB is available in Scalingo PostgreSQL databases starting with the version 13.6.0-1.

To enable TimescaleDB, provision a new PostgreSQL database and execute the following SQL command:

CREATE EXTENSION timescaledb;

That’s it, TimescaleDB Open-source is enabled on your database!

There are multiple licenses of TimescaleDB, Community edition and Open-source edition. The latter is the only one available on Scalingo, hence TimescaleDB’s functions labeled “community” on their documentation are not available on the platform.

Working with time series database usually involves the need to compress data in runtime and remove the oldest data. We show you how to configure it so that it is done automatically:

• Downsampling
• Data retention
• Dump and restore