Adding TimescaleDB to Postgres

Ignition
1

I’ve got a current PostgresDB system with a few partitions so far and I’m interested to converting to TimescaleDB.

I found this guide (thanks @michael.flagler - for sharing!). I’ve also seen some methods of migrating the old data to the new TimescaleDB table; I was wondering if this would even be required if I’m alright with the old partitions being slow/ in standard tables?

My thought would be to disable pruning in Ignition and convert the sqlth_1_data table to a hypertable. Ideally, queries on the new data would fully utilize TimescaleDB, and queries that access the old data would still work.

2

I think you're on the right track. You could possibly even use the guide to convert all the old tables to hyper tables if you wanted. In theory it should work. Make sure to disable both pruning and partitioning.

At this point you'll have to drop the old tables yourself whenever you don't need them.

1 Like