Skip to main content
1-Visitor
November 20, 2017
Question

Maintaining Thingworx Data Size

  • November 20, 2017
  • 1 reply
  • 1431 views

Hello,

I've been using the "PurgePropertyHistory" service to delete data from my value streams. The data appears to have been deleted successfully  (when I "QueryPropertyHistory", the resulting infotable returns with no rows).

However, after I run the "PurgePropertyHistory" service, the size of the Postgres database INCREASES significantly. Would someone please explain why the size of the database would increase? I would like to free up space on the database, does anyone have any suggestions? The data is stored on its own drive, separate to any log files.


Thanks

1 reply

1-Visitor
November 20, 2017

I think you should simply need to search on Purge/Compact/Vacuum a PostgreSQL database on public internet, this is not a TW specific job.