Thread: autovacuum?

autovacuum?

From
"Hank Hsiung"
Date:
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?
 
TIA,
Hank

Re: autovacuum?

From
"Jim C. Nasby"
Date:
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
processand is integrated into postgres. However, I can't tell if my database has autovacuumed. I've turned on the
configurationsin 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@decibel.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?"


Re: autovacuum?

From
"George Pavlov"
Date:
> 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"

Not sure why this thread is on pgadmin-support (general would be a
better place for it), but do note that as far as I know the log lines
you are referring to only indicate that autovacuum is processing the
database to see if it needs vacuuming -- there may not be any actual
vacuuming going on, because of, for example, your entries in the
pg_autovacuum system table.