pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: robin <robin@edesix.com>
To: pgsql-admin@postgresql.org
Subject: Re: Giant Postgresql Database Cluster Folder
Date: Tue, 10 Apr 2012 08:19:58 +0100
Message-ID: <fe872692b2861f6c1a94be6007aeef0f@edesix.com> (raw)
In-Reply-To: <CALnrrJSkAK4rLZ7o6BoYzsP18gYMw+KogvUc=7GakuO6TQxE6Q@mail.gmail.com>
References: <CAMC_Rtv1VE8MEsuj86btZu3gRGQCx-8TUzHnjEUrOJd6dEgRrw@mail.gmail.com>
	<CALnrrJSkAK4rLZ7o6BoYzsP18gYMw+KogvUc=7GakuO6TQxE6Q@mail.gmail.com>

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?




view thread (3+ messages)

Message-ID: <fe872692b2861f6c1a94be6007aeef0f@edesix.com>
Permalink:  ../fe872692b2861f6c1a94be6007aeef0f@edesix.com/
Also on:    postgresql.org/message-id/fe872692b2861f6c1a94be6007aeef0f@edesix.com

 · 

reply
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-admin@postgresql.org
  Cc: robin@edesix.com
  Subject: Re: Giant Postgresql Database Cluster Folder
  In-Reply-To: <fe872692b2861f6c1a94be6007aeef0f@edesix.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