Subject: Re: Disk Space issue
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Devendra Singh Rawat <Devendra_Rawat@infosys.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <4242E42288B6E842A52B88D4B3A3E620E0610550@AUSMELMBX01.ad.infosys.com>
References: <484E61A0.5030706@kerkhove.net> <484E88AB.6020505@kerkhove.net>
	<4242E42288B6E842A52B88D4B3A3E620E0610550@AUSMELMBX01.ad.infosys.com>
Content-Type: text/plain
Organization: Command Prompt, Inc.
Date: Tue, 10 Jun 2008 16:55:15 -0700
Message-Id: <1213142115.17340.213.camel@jd-laptop>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit


On Wed, 2008-06-11 at 09:36 +1000, Devendra Singh Rawat wrote:
> Hi,
> 
> We are using PostgreSQL 7.4.5 and facing issues with increasing disk space.
> 
> Here is some information about our configuration.
> 
> The data dump size is around 3 GB. And it is occupying around 120GB on the disk. When we recreate the database from data dump it takes around 3.5GB of disk space.
> But the database size increases by 1 GB daily though actual data added maybe in KB. We are not able to decipher as to what is causing this increase.
> 
> Suggestions on the likely problems will be appreciated.

You are likely not vacuuming nearly enough.

I would also suggest strongly you update to the latest 7.4 dot release.

Joshua D. Drake

> 
> Regards,
> Devendra
> 
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
> for the use of the addressee(s). If you are not the intended recipient, please 
> notify the sender by e-mail and delete the original message. Further, you are not 
> to copy, disclose, or distribute this e-mail or its contents to any other person and 
> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken 
> every reasonable precaution to minimize this risk, but is not liable for any damage 
> you may sustain as a result of any virus in this e-mail. You should carry out your 
> own virus checks before opening the e-mail or attachment. Infosys reserves the 
> right to monitor and review the content of all messages sent to or from this e-mail 
> address. Messages sent to or from this e-mail address may be stored on the 
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***
>