Re: VACUUM ANALYZE--how often? - Mailing list pgsql-admin

From Jeff Boes
Subject Re: VACUUM ANALYZE--how often?
Date
Msg-id 20020116083943.4c0a4cdb.jboes@nexcerpt.com
Whole thread Raw
In response to Re: VACUUM ANALYZE--how often?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Wed, 16 Jan 2002 00:42:52 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> > VACUUM ANALYZE takes over an hour, and it's edging up by a couple
> > minutes per day.
>
> Care to try 7.2?
>

We will, but due to other issues we can't until things stabilize in
some other areas.  Even then, how often is just often enough?  Is it
different in 7.1 and 7.2?

--
Jeff Boes                                             vox 616.226.9550
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                      jboes@nexcerpt.com

pgsql-admin by date:

Previous
From: Rasmus Mohr
Date:
Subject: client connection problem
Next
From: "Nick Fankhauser"
Date:
Subject: Re: client connection problem