From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
---|---|
To: | Jean-Christophe ARNU (JX) <jc(dot)arnu(at)free(dot)fr>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Index file size keeps on growing..... |
Date: | 2002-05-26 10:28:18 |
Message-ID: | 200205261558.18583.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Jean,
Have you tried REINDEX?
what version of postgresql is it?
regds
mallah.
On Thursday 23 May 2002 01:10 pm, Jean-Christophe ARNU (JX) wrote:
> Hi all,
> I'm in front of a real problem (from my point of view). I have some tables
> with a lot of update insert and delete (24/7). These tables have multiples
> indexes. Major part of Insert commands are performed as bulk at 00:00:00.
> I'm doing Vaccum and then a vacuum analyze to clean tables (well done) and
> update indexes (also performed) BUT index are not "cleaned" in the way
> their size keeps on growing in size...
> The real problem is that I have tables that takes about 20MB each and
> index around 190MB (for some of them). The only way I found to reduce index
> file size is to destroy the incriminated indexes and recreate, praying for
> select not to happen between drop and create operation (I cannot afford
> table lock)...
>
> So is this a correct Postgres Behaviour?
> Do I have a neat way to make my index keep a reasonnable size?
> Did I missed something in the config file and/or with the vacuum commands?
>
> Thanks for any clue!!
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah. | 2002-05-26 10:30:15 | Re: File systems backup problem |
Previous Message | Jyry Kuukkanen | 2002-05-26 08:24:19 | Re: How to change datatype of a field |