Re: index keeps on growing

From: Marc Spitzer <marc(at)oscar(dot)eng(dot)cv(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: index keeps on growing
Date: 2002-06-19 18:04:07
Message-ID: 20020619140407.A92750@oscar.eng.cv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message ashwini sridhar 2002-06-19 18:57:48 UNSUBSCRIBE ME!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Previous Message Robson 2002-06-19 17:24:40 Err Access PgAdmin