Joao Ferreira gmail wrote:
vacuum/reindex is saying: I can't do it cause I have no space :(
how do I un-bloat the /var partition ? this is why I was considering
rm !!!!
I've gotten out of this situation before by finding other files in /var
to delete, using something like this to figure out where the big stuff
was at:
du -sk | sort -n
And then once a little room was available, using CLUSTER starting on the
smallest tables, identified with a query like the one at
http://wiki.postgresql.org/wiki/Disk_Usage except with different LIMITs
on it. Once some of those are shrunk, you might be able to work your
way up to bigger ones.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg@xxxxxxxxxxxxxxx www.2ndQuadrant.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
