Trigger creation of pre-processed partitions for historic data

Hi,

We have been using the Ignition Tag History provider with a PostgreSQL database for quite some time now. Due to the large volume of data accumulated, some queries are taking very long. We have had the default data partitioning enabled from the start, with partitions set to 1 month.

Yesterday, I enabled the Pre-processed Partitions to test if this would improve query times. After enabling it, I noticed that Ignition only pre-processed the data for the current monthly partition. As a result, query times only improved when requesting recent data.

Is there any way to trigger Ignition to pre-process all previous partitions as well?

After talking to support, they let me know that there is no current implementation to trigger the pre-process data for older partitions.

1 Like