Re: [ADMIN] Disk Space issue

2008-06-11 Thread Devendra Singh Rawat
| 374 Regards, Devendra -Original Message- From: Praveen Kumar (TUV) [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 June 2008 4:15 PM To: Devendra Singh Rawat; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Disk Space issue Hi, I think you have a lot DML operation in y

Re: [ADMIN] Disk Space issue

2008-06-10 Thread Devendra Singh Rawat
Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 June 2008 10:06 AM To: Devendra Singh Rawat Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Disk Space issue On Wed, 2008-06-11 at 09:58 +1000, Devendra Singh Rawat wrote: > Hi Joshua, > > We used Vacuum

Re: [ADMIN] Disk Space issue

2008-06-10 Thread Devendra Singh Rawat
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: [EMAIL PROTECTED

[ADMIN] Disk Space issue

2008-06-10 Thread Devendra Singh Rawat
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. B