index keeps on growing

From: Jean-Christophe ARNU (JX) <jc(dot)arnu(at)free(dot)fr>
To: pgsql-admin(at)postgresql(dot)org
Subject: index keeps on growing
Date: 2002-06-19 09:09:00
Message-ID: 20020619090900.082ec544.jc.arnu@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,
I've a hard working pgsql db running on 7/7x365 server. Each night
(when
activity is less intensive) I run vacuum and vacuum analyze on tables where
principal activity is performed.
Tables are cleaned (files sizes are decreasing), but indices files
keeps on
growing in size....

I run PgSQL 7.1.3, I cannot upgrade (immediately) to 7.2.x... So what
can I
do to keep these indices' size at a constant and reasonnable size?

Thanks a lot

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robson 2002-06-19 11:19:17 Help - Not found date
Previous Message Heni Lolov 2002-06-19 09:06:53 Re: create table permission