I need to run VACUUM FULL with no available disk space
47
votes
5
answers
63556
views
I have one table that is taking up close to 90% of hd space on our server. I have decided to drop a few columns to free up space. But I need to return the space to the OS. The problem, though, is that I'm not sure what will happen if I run VACUUM FULL and there is not enough free space to make a copy of the table.
I understand that VACUUM FULL should not be used but I figured it was the best option in this scenario.
Any ideas would be appreciated.
I'm using PostgreSQL 9.0.6
Asked by Justin Rhyne
(573 rep)
Apr 25, 2012, 08:31 PM
Last activity: Aug 9, 2024, 10:09 AM
Last activity: Aug 9, 2024, 10:09 AM