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*** >
