Re: index keeps on growing

On Wed, Jun 19, 2002 at 09:09:00AM +0000, Jean-Christophe ARNU wrote:
> 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

As far as I know there are 2 ways to do this:
1: the command "reindex table_name" to rebuild all your indexes on a table,
I think it locks the table
2: drop and recreate the indexes by hand

marc

ps the first time you reindex it can take a long time.


>
>
> --
> Jean-Christophe ARNU
> s/w developer
> Paratronic France
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly