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: 4fc81d760701041715s28548ff0s763cbf05331b6c12@mail.gmail.com (view raw or flat)
Thread:
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
log.

http://www.postgresql.org/docs/current/static/release-8-2.html

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
activity."

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-2014 The PostgreSQL Global Development Group