Index file size keeps on growing.....

From: Jean-Christophe ARNU (JX) <jc(dot)arnu(at)free(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: Index file size keeps on growing.....
Date: 2002-05-23 07:40:53
Message-ID: 20020523064053.1a99b535.jc.arnu@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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!!

--
Jean-Christophe ARNU
s/w developer
Paratronic France

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message l.malaspina 2002-05-23 10:37:59 File systems backup problem
Previous Message William Meloney 2002-05-23 02:35:02 Re: Log entry: srm: Permission Denied (Answered)