| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Mitch Collinsworth <mitch(at)ccmr(dot)cornell(dot)edu> |
| Cc: | Joshua D(dot) Drake <jd(at)commandprompt(dot)com>, Doug Gorley <doug(dot)gorley(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How can I tell if I'm autovacuuming? |
| Date: | 2010-05-25 19:53:49 |
| Message-ID: | 1274817042-sup-6782@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Excerpts from Mitch Collinsworth's message of mar may 25 15:38:38 -0400 2010:
> On Tue, 25 May 2010, Alvaro Herrera wrote:
> > I'd say you're running 8.1, not 8.2 as initially stated.
>
> Well... yes. Sorry. I take it the answer is different then...
>
> So... How can I tell if I'm autovacuuming in 8.1.21?
Crank log_min_messages down to debug2 and check the log for DEBUG
messages talking about databases and tables processed by autovacuum.
(I think debug1 produces enough data, I can't recall precisely).
8.1 was the first release to sport integrated autovacuum. It was very
rough around the edges. If you're depending on its behavior, I suggest
you upgrade.
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
Command Prompt, Inc. -- The PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samuel Stearns | 2010-05-25 22:45:05 | Re: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3 |
| Previous Message | Mitch Collinsworth | 2010-05-25 19:38:38 | Re: How can I tell if I'm autovacuuming? |