Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
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
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.