Thread: Autovacuum not running in 8.2.0

Autovacuum not running in 8.2.0

From
Ming
Date:
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

Re: Autovacuum not running in 8.2.0

From
"Shoaib Mir"
Date:
What is your current logging level that is been set in the conf file?

--------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/4/07, Ming <ming8080@gmail.com > 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?

Regards,

Ming

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Autovacuum not running in 8.2.0

From
"Simon Riggs"
Date:
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



Re: Autovacuum not running in 8.2.0

From
"Daniel Cristian Cruz"
Date:
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

Re: Autovacuum not running in 8.2.0

From
Ming
Date:
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.