Store allows you to save time series data in TimescaleDB or PostgreSQL databases. It uses a native PostgreSQL driver to interact with the database and provides high reliability and performance.
Key Features
- Flexible tuning of writing performance
- Verification of SSL server certificate
- Flexible tuning of time series metadata and database design
- Built-in TimescaleDB support
Note that by default, store uses TimescaleDB as the target database. Before you start, make sure that the TimescaleDB extension is installed and functioning correctly. The store is intended for PostgreSQL versions 9.6 and higher. For TimescaleDB we recommend using PostgreSQL 10.2 or higher because It provides a data compression mechanism
We strongly recommend using TimescaleDB as it has several advantages over traditional PostgreSQL:
- High performance at INSERTs and SELECTs
- Fast removal of old data
- Automatic data compression