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
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 |