Обсуждение: Autovacuum not running in 8.2.0

Hi, I recently upgraded from 8.1.4 to 8.2.0, everything was fine
except that I suspect that the autovacuum was not running. In
pgAdmin's server properties, the "Autovacuum" property shows
"runnning", but I couldn't find any log entry for the autovacuum
process. I've set the new postgresql.conf to match the old one (from
the 8.1.4 install), especially the autovacuum entries, but still I
couldn't find any log entry for the process (The logging works fine, I
tried to supply a wrong login password, and the login failure was
successfully logged). Has anyone experienced similar issue?

Regards,

Ming

On Thu, 2007-01-04 at 11:30 +0700, Ming wrote:
> Hi, I recently upgraded from 8.1.4 to 8.2.0, everything was fine
> except that I suspect that the autovacuum was not running. In
> pgAdmin's server properties, the "Autovacuum" property shows
> "runnning", but I couldn't find any log entry for the autovacuum
> process. I've set the new postgresql.conf to match the old one (from
> the 8.1.4 install), especially the autovacuum entries, but still I
> couldn't find any log entry for the process (The logging works fine, I
> tried to supply a wrong login password, and the login failure was
> successfully logged). Has anyone experienced similar issue?

Yes, its not very easy to determine if it is working, and if it is, what
it has done.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com

Try looking at pg_stat_all_tables at these columns:

last_vacuum
last_autovacuum
last_analyze
last_autoanalyze

Kind regards.

On 1/4/07, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Thu, 2007-01-04 at 11:30 +0700, Ming wrote:
> > Hi, I recently upgraded from 8.1.4 to 8.2.0, everything was fine
> > except that I suspect that the autovacuum was not running. In
> > pgAdmin's server properties, the "Autovacuum" property shows
> > "runnning", but I couldn't find any log entry for the autovacuum
> > process. I've set the new postgresql.conf to match the old one (from
> > the 8.1.4 install), especially the autovacuum entries, but still I
> > couldn't find any log entry for the process (The logging works fine, I
> > tried to supply a wrong login password, and the login failure was
> > successfully logged). Has anyone experienced similar issue?
>
> Yes, its not very easy to determine if it is working, and if it is, what
> it has done.
>
> --
>   Simon Riggs
>   EnterpriseDB   http://www.enterprisedb.com
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>


--
Daniel Cristian Cruz
Analista de Sistemas
Especialista postgreSQL e Linux
Instrutor Certificado Mandriva

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.