up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

1 Answer

up vote 1 down vote

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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