| From: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
|---|---|
| To: | Hank Hsiung <hankh(at)telepaq(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org, CF Wang <cfw(at)telepaq(dot)com>, TimC <TimC(at)telepaq(dot)com> |
| Subject: | Re: autovacuum? |
| Date: | 2006-05-17 21:18:59 |
| Message-ID: | 20060517211858.GJ26212@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Wed, May 17, 2006 at 05:04:56PM +0800, Hank Hsiung wrote:
> Hi list,
>
> I am using Postgresql version 8.1. It has been announced that in this version, autovacuum is no longer a seperate process and is integrated into postgres. However, I can't tell if my database has autovacuumed. I've turned on the configurations in the autovacuum section in postgresql.conf. What else should I do to make it happen?
If you look in your logs, you should see something like:
May 17 13:24:49 fritz postgres[13852]: [3-1] LOG: autovacuum: processing database "postgres"
Though, that probably depends on your logging settings.
--
Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John DeSoi | 2006-05-18 00:02:47 | pg schema prefix |
| Previous Message | Dave Page | 2006-05-17 15:38:32 | Re: role with "CREATEDB" and "CREATEROLE" without effect on GUI |