Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum not running in 8.2.0

From: Ming <ming8080(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Autovacuum not running in 8.2.0
Date: 2007-01-05 01:15:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I already found the answer, sorry... my mistake for not checking the
8.2.0 release note first. It turns out that such behaviour is expected
in 8.2.0, i.e. autovacuum process no longer add an entry to the server

But then, another question arises... how could I know whether it's
working if it does not add any entry to the log?

an excerpt from the above link: "pg_stat_activity now shows autovacuum

I expected to see a new process showing up in pgAdmin's Server Status
window while autovacuum is running, but there was none.

In response to

pgsql-admin by date

Next:From: ArnauDate: 2007-01-05 10:33:42
Subject: Re: I want to import a database from a customer
Previous:From: Ben K.Date: 2007-01-04 23:31:10
Subject: Re: Dump and Query (fwd)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group