Sample Header Ad - 728x90

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