| From: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: VACUUM ANALYZE--how often? |
| Date: | 2002-01-16 13:39:43 |
| Message-ID: | 20020116083943.4c0a4cdb.jboes@nexcerpt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 16 Jan 2002 00:42:52 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)nexcerpt(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rasmus Mohr | 2002-01-16 13:52:03 | client connection problem |
| Previous Message | Roman Gavrilov | 2002-01-16 08:09:17 | Re: Monitoring database |