Brandon Shalton wrote:
> Hello all,
> My hard disk is filling up in the /base directory to where it has
> consumed all 200gig of that drive.
> All the posts that i see keep saying move to a bigger drive, but at
> some point a bigger drive would just get consumed.
> How can i keep the disk from filling up other than get like a half TB
> setup just to hold the ./base/* folder
Two things come to mind:
- Vacuum as already mentioned by others.
- Temporary sort files from queries needing to sort massive amounts of data.
But you need to help us out by supplying more info...
In response to
pgsql-performance by date
|Next:||From: Alvaro Herrera||Date: 2007-07-27 08:58:05|
|Subject: Re: User concurrency thresholding: where do I look?|
|Previous:||From: Jim Nasby||Date: 2007-07-26 23:27:59|
|Subject: Re: Affect of Reindexing on Vacuum Times|