MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Tue, 10 Apr 2012 08:19:58 +0100
From: robin <robin@edesix.com>
To: <pgsql-admin@postgresql.org>
Subject: Re: Giant Postgresql Database Cluster Folder
In-Reply-To: 
 <CALnrrJSkAK4rLZ7o6BoYzsP18gYMw+KogvUc=7GakuO6TQxE6Q@mail.gmail.com>
References: 
 <CAMC_Rtv1VE8MEsuj86btZu3gRGQCx-8TUzHnjEUrOJd6dEgRrw@mail.gmail.com>
	<CALnrrJSkAK4rLZ7o6BoYzsP18gYMw+KogvUc=7GakuO6TQxE6Q@mail.gmail.com>
Message-ID: <fe872692b2861f6c1a94be6007aeef0f@edesix.com>
User-Agent: Roundcube Webmail/0.5.3

Given your data set is small so a dump/restore cycle is painless, you 
should also consider upgrading to the latest stable release.

I agree with Raghu that you need to vacuum your database periodically 
to keep it's footprint under control, but rather than doing the VACUUM 
commands via scheduled activity you should use the auto vacuum daemon 
unless you have specific needs.  You probably do need to do the first 
vacuum by hand with no users connected (or do a dump/restore cycle which 
is perhaps quicker with a system as bloated as yours).

http://www.postgresql.org/docs/8.2/static/routine-vacuuming.html#AUTOVACUUM

Given you missed the need to vacuum I would read the whole routine 
maintenance section in case there are other activities that you should 
be performing to keep your data safe and available:

http://www.postgresql.org/docs/8.2/static/maintenance.html

Hope this helps,

Robin


On Tue, 10 Apr 2012 11:44:08 +0530, raghu ram wrote:
> On Tue, Apr 10, 2012 at 11:21 AM, Kiruba suthan  wrote:
>
>> Could you help me how to clean up DB Cluster folder and reclaim disk
>> space please? And please give me some insight into how data is
>> organized in DB Cluster and what should I do to avoid this happening
>> again?