From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
---|---|
To: | "Brandon Shalton" <brandon(at)cydataservices(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: disk filling up |
Date: | 2007-07-26 13:34:32 |
Message-ID: | 20070726093432.bbb28fea.wmoran@collaborativefusion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023
From | Date | Subject | |
---|---|---|---|
Next Message | Jignesh K. Shah | 2007-07-26 14:29:51 | Re: User concurrency thresholding: where do I look? |
Previous Message | angga erwina | 2007-07-26 08:44:19 | performance of postgresql in replication using slony |