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