From: Bill Moran <wmoran@collaborativefusion.com>
To: Brandon Shalton <brandon@cydataservices.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: disk filling up
Date: Thu, 26 Jul 2007 09:34:32 -0400
Message-ID: <20070726093432.bbb28fea.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <009c01c7cfa0$ab526810$fc01a8c0@blaptop>
References: <009c01c7cfa0$ab526810$fc01a8c0@blaptop>
In response to "Brandon Shalton" <brandon@cydataservices.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@collaborativefusion.com
Phone: 412-422-3463x4023
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wmoran@collaborativefusion.com, brandon@cydataservices.com
Subject: Re: disk filling up
In-Reply-To: <20070726093432.bbb28fea.wmoran@collaborativefusion.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox