Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I had a 103GB (pgAdmin III reported it as such in 'Statistics' of the table) table in Postgresql 8.4. I dropped it. Since then, its only recovered about 60GB worth of space back to the system ....

Where'd the rest of it go and what can I do to get it back?

share|improve this question

Probably need to do a vacuum?

share|improve this answer
And a quote from the manual entry "Therefore it's necessary to do VACUUM periodically, especially on frequently-updated tables." – Tim Dec 8 '11 at 21:00
I dropped the table can I vacuum something that doesn't exist? – rfusca Dec 8 '11 at 22:18
If I had just deleted I wouldn't get any space back until a vacuum full or cluster anyway. – rfusca Dec 8 '11 at 22:19
oh yeah... woops – Tim Dec 9 '11 at 1:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.