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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly