The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.
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.