References
Sources, credits and further reading.
This guide's sources
- TimescaleDB + Ignition Setup (PDF): the Ubuntu and Ignition walk-through. © 2024 Agile Automation Technology, LLC, by Peter Tiagunov, revision 1.1, 12 February 2024.
- TimescaleDB Documentation (PDF): the Windows install, the SQL Server comparison and the migration outline.
- The original page of this guide, which covered the Windows install and the hypertable commands. It is now spread over Install on Windows and Hypertable setup.
Compared against
- Integrate Ignition with Tiger Cloud (Tiger Data documentation, undated, read 30 October 2026): the current Ignition setup with the columnstore names and millisecond policy ages.
- Ignition and TimescaleDB: a perfect pairing (Tiger Data blog, 17 April 2026, by Doug Pagnutti): the background and the same steps. It uses
INTERVALages for the policies, which this guide does not follow (see Hypertable setup).
Credits in the Setup PDF
The Ubuntu part is partly based on Timescale's Linux installation guide, with additions for Ignition. The lab used a free ESXi 7.0U3g host from VMware, PostgreSQL 14.10, pgAdmin 4 version 8.2, and a time-limited licence of Ignition 8.1.37 LTS.
Further reading
Ignition and Timescale
- Ignition Tag Historian module
- Ad Hoc Trends on the Ignition Exchange
- Ignition and TimescaleDB, from Tiger Data
- Install self-hosted TimescaleDB on Linux
- TimescaleDB releases
BRIN indexes
- BRIN indexes, PostgreSQL documentation
- BRIN index for PostgreSQL: don't forget the benefits, by Percona
- Postgres indexing: when does BRIN win? by Paul Ramsey
- Create a BRIN index at a fraction of the normal size, by Digoal Zhou
Autovacuum
- Optimizing Postgres autovacuum for high-churn tables, by Adam Hendel
- Enabling and disabling autovacuum in PostgreSQL, by Hans-Jürgen Schönig
Newer TimescaleDB versions