Re: Postgres performance slowly gets worse over a month

On Thu, Aug 08, 2002 at 02:06:57PM -0400, Robert M. Meyer wrote:
> have a contractor that did the reindex for us so I'm not sure of the
> process at this point.  I suspect that it's something like;
> 1. shut down postgres
> 2. run 'postgres -O -P' to start a single user instantiation of the
> engine
> 3. type 'reindex' to get it to do it
> 4. exit postgres and restart the DB with pg_ctl
>
> Does that sound about right?

What you are talking about there is reindexing the system tables.
But "recreating the indexes" as a solution to file growth and
performance problems is not this.  Instead, what you do is drop the
index and recreate it.  At least, that's what I have gathered from
the "reindex" scripts that were sent to the -general list a little
while ago.

> Any other suggestions?

Yes.  As someone else suggested, it sounds like you need a full-time
DBA, at least for a little while.

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110