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*** > -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
