Hi
I have a large database (multi TB) which had a vacuum full running but the database ran out of space during the rebuild of one of the large data tables.
Cleaning down the WAL files got the database restarted (an archiving problem led to the initial disk full).
However, the disk space is still at 99% as it appears the large table rebuild files are still hanging around using space and have not been deleted.
My problem now is how do I get this space back to return my free space back to where it should be?
I tried some scripts to map the data files to relations but this didn't work as removing some files led to startup failure despite them appearing to be unrelated to anything in the database - I had to put them back and then startup worked.
Any suggestions here?
Thanks
Tom
