cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Maintaining Thingworx Data Size

kdonald
1-Visitor

Maintaining Thingworx Data Size

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

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.

Announcements


Top Tags