| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: safelly erasing dirs/files |
| Date: | 2009-11-15 05:40:56 |
| Message-ID: | 4AFF9468.7060500@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)2ndQuadrant(dot)com www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | undisclosed user | 2009-11-15 06:28:22 | Experience with many schemas vs many databases |
| Previous Message | Craig Ringer | 2009-11-15 02:56:53 | Re: all empty tables |