index keeps on growing - Mailing list pgsql-admin

From Jean-Christophe ARNU (JX)
Subject index keeps on growing
Date
Msg-id 20020619090900.082ec544.jc.arnu@free.fr
Whole thread Raw
Responses Re: index keeps on growing
Re: index keeps on growing
List 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

pgsql-admin by date:

Previous
From: David Stanaway
Date:
Subject: Re: Uppercase field names not found
Next
From: Heni Lolov
Date:
Subject: Re: create table permission