From: | scorpdaddy(at)hotmail(dot)com <scorpdaddy(at)hotmail(dot)com> |
---|---|
To: | Rajendra prasad <rajendra(dot)dn(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [ADMIN] Index size growing |
Date: | 2011-04-01 10:06:39 |
Message-ID: | BLU0-SMTP165C20CDD5596112877E0F3CEBE0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
How recent is the vacuum in this DB?
----- Reply message -----
From: "Rajendra prasad" <rajendra(dot)dn(at)gmail(dot)com>
Date: Thu, Mar 31, 2011 11:01 pm
Subject: [ADMIN] Index size growing
To: <pgsql-admin(at)postgresql(dot)org>
Hi,
I have 50 GB data base folder for postgres. Out of 50 GB 20 GB has been
occupied by 8 indexes of a single table by growing upto 2 GB each. I googled
and got the info that reindex will help brining back the actual size of the
index. But the disk has only 4 GB left . Due to this, when i run reindex it
is getting almost full. I don't know exactly why it is growing like that
during reindex. Due to this i am not able to complete the reindex and see if
i get back the disk spacce. Please suggest me a good solution and the way
that i am doing is logical or not.
Regards,
Rajendra
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Sievers | 2011-04-01 11:28:31 | Re: Index size growing |
Previous Message | Vladimir Rusinov | 2011-04-01 10:02:11 | Re: Restore Backup from Linux to Windows 2003 |