Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

Probably need to do a vacuum? http://www.postgresql.org/docs/8.3/static/sql-vacuum.html

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 ....how 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

 
discard

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.