| From: | Jean-Christophe ARNU (JX) <jc(dot)arnu(at)wanadoo(dot)fr> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | index keeps on growing |
| Date: | 2002-06-18 17:02:14 |
| Message-ID: | 20020618170214.1568a89e.jc.arnu@wanadoo.fr |
| Views: | Whole Thread | Raw Message | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cliff Wells | 2002-06-18 17:12:32 | Removing records that violate foreign key |
| Previous Message | Oliver Elphick | 2002-06-18 16:43:33 | Re: set permanent date style |