Postgres Pro
Downloads
Home   >   mailing lists

index keeps on growing - Mailing list pgsql-admin

From Jean-Christophe ARNU (JX)
Subject index keeps on growing
Date
Msg-id 20020618170214.1568a89e.jc.arnu@wanadoo.fr
Whole thread Raw
List pgsql-admin
Tree view 
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: "Michael P. Dobmeier"
Date:
Subject: Some questions regarding authentication (via pg_hba.conf password pwfile)
Next
From: "Camilo Villarreal"
Date:
Subject: Help! sed: command garbled compiling on Solaris7