PostgreSQL Connectivity

Store allows you to save time series data in PostgreSQL database. 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.

  • OPC UA Historical access (raw/aggregated data reading).

We strongly recommend using TimescaleDB extension as it has several advantages over traditional PostgreSQL:

  • High performance at INSERTs and SELECTs

  • Fast removal of old data

  • Automatic data compression

Last updated