Re: Disk Space issue
От | Devendra Singh Rawat |
---|---|
Тема | Re: Disk Space issue |
Дата | |
Msg-id | 4242E42288B6E842A52B88D4B3A3E620E0610579@AUSMELMBX01.ad.infosys.com обсуждение исходный текст |
Ответ на | Re: Disk Space issue ("Joshua D. Drake" <jd@commandprompt.com>) |
Ответы |
Re: Disk Space issue
("Joshua D. Drake" <jd@commandprompt.com>)
|
Список | pgsql-admin |
Hi Joshua, We used Vacuum Full but were not successful. The reclaimed disk space was only few MB. I did not get to which version I need to update my Postgres. Regards, Devendra Devendra Singh Rawat Infosys Technologies Ltd. Tel: +61 3 9860 2276 (D) Fax: +61 3 9860 2501 Email: devendra_rawat@infosys.com www.infosys.com Powered by Intellect Driven by Values -----Original Message----- From: Joshua D. Drake [mailto:jd@commandprompt.com] Sent: Wednesday, 11 June 2008 9:55 AM To: Devendra Singh Rawat Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Disk Space issue 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 datadump 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 whatis 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*** >
В списке pgsql-admin по дате отправления: