In response to "Brandon Shalton" <brandon(at)cydataservices(dot)com>:
> 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
Are you vacuuming regularly? What is the output of vacuum verbose.
If table bloat (fixed by correctly vacuuming) is not your problem, then
you either need to implement a data expiration policy to get rid of
old data, or increase the amount of storage to accommodate the data
you want to keep.
Collaborative Fusion Inc.
In response to
pgsql-performance by date
|Next:||From: Jignesh K. Shah||Date: 2007-07-26 14:29:51|
|Subject: Re: User concurrency thresholding: where do I look?|
|Previous:||From: angga erwina||Date: 2007-07-26 08:44:19|
|Subject: performance of postgresql in replication using slony|