pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Autovacuum not running in 8.2.0
5+ messages / 4 participants
[nested] [flat]

* Autovacuum not running in 8.2.0
@ 2007-01-04 04:30  Ming <ming8080@gmail.com>
  0 siblings, 3 replies; 5+ messages in thread

From: Ming @ 2007-01-04 04:30 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Autovacuum not running in 8.2.0
@ 2007-01-04 09:05  Shoaib Mir <shoaibmir@gmail.com>
  parent: Ming <ming8080@gmail.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Shoaib Mir @ 2007-01-04 09:05 UTC (permalink / raw)
  To: Ming <ming8080@gmail.com>; +Cc: pgsql-admin

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
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Autovacuum not running in 8.2.0
@ 2007-01-04 10:33  Simon Riggs <simon@2ndquadrant.com>
  parent: Ming <ming8080@gmail.com>
  2 siblings, 1 reply; 5+ messages in thread

From: Simon Riggs @ 2007-01-04 10:33 UTC (permalink / raw)
  To: Ming <ming8080@gmail.com>; +Cc: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Autovacuum not running in 8.2.0
@ 2007-01-04 11:45  Daniel Cristian Cruz <danielcristian@gmail.com>
  parent: Simon Riggs <simon@2ndquadrant.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Daniel Cristian Cruz @ 2007-01-04 11:45 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Autovacuum not running in 8.2.0
@ 2007-01-05 01:15  Ming <ming8080@gmail.com>
  parent: Ming <ming8080@gmail.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Ming @ 2007-01-05 01:15 UTC (permalink / raw)
  To: 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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-01-05 01:15 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-04 04:30 Autovacuum not running in 8.2.0 Ming <ming8080@gmail.com>
2007-01-04 09:05 ` Shoaib Mir <shoaibmir@gmail.com>
2007-01-04 10:33 ` Simon Riggs <simon@2ndquadrant.com>
2007-01-04 11:45   ` Daniel Cristian Cruz <danielcristian@gmail.com>
2007-01-05 01:15 ` Ming <ming8080@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox