Index size growing

From: Rajendra prasad <rajendra(dot)dn(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Index size growing
Date: 2011-04-01 02:01:40
Message-ID: AANLkTik6kMGP=k7x_Eyk0ydwVVv_zKLYy6P45UN0BDoX@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Selva manickaraja 2011-04-01 02:14:03 Re: Too many WAL(s) despite low transaction
Previous Message Stephen Frost 2011-04-01 01:38:53 Re: Too many WAL(s) despite low transaction