I think you have a lot DML operation in your database and you are not
vacuuming your database . So try to execute command vacuum analyze
<<table name >>; in your schema where you are facing problem.
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Devendra Singh
Sent: Wednesday, June 11, 2008 5:07 AM
Subject: [ADMIN] Disk Space issue
We are using PostgreSQL 7.4.5 and facing issues with increasing disk
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
Suggestions on the likely problems will be appreciated.
**************** 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***
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make
changes to your subscription:
pgsql-admin by date
|Next:||From: Richard Huxton||Date: 2008-06-11 07:07:28|
|Subject: Re: what gives: SELECT INVALID SELECT STATEMENT TO FORCE
ODBC DRIVER TO UNPREPARED STATE|
|Previous:||From: Richard Broersma||Date: 2008-06-11 04:06:13|
|Subject: what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE|