From: Joshua D. Drake <jd@commandprompt.com>
To: Devendra Singh Rawat <Devendra_Rawat@infosys.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Disk Space issue
Date: Tue, 10 Jun 2008 16:55:15 -0700
Message-ID: <1213142115.17340.213.camel@jd-laptop> (raw)
In-Reply-To: <4242E42288B6E842A52B88D4B3A3E620E0610550@AUSMELMBX01.ad.infosys.com>
References: <484E61A0.5030706@kerkhove.net>
<484E88AB.6020505@kerkhove.net>
<4242E42288B6E842A52B88D4B3A3E620E0610550@AUSMELMBX01.ad.infosys.com>
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***
>
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: jd@commandprompt.com, Devendra_Rawat@infosys.com
Subject: Re: Disk Space issue
In-Reply-To: <1213142115.17340.213.camel@jd-laptop>
* 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