pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAutovacuum 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>
2007-01-04 09:05 ` Re: Autovacuum not running in 8.2.0 Shoaib Mir <shoaibmir@gmail.com>
2007-01-04 10:33 ` Re: Autovacuum not running in 8.2.0 Simon Riggs <simon@2ndquadrant.com>
2007-01-05 01:15 ` Re: Autovacuum not running in 8.2.0 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 04:30 Autovacuum not running in 8.2.0 Ming <ming8080@gmail.com>
@ 2007-01-04 09:05 ` Shoaib Mir <shoaibmir@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 04:30 Autovacuum not running in 8.2.0 Ming <ming8080@gmail.com>
@ 2007-01-04 10:33 ` Simon Riggs <simon@2ndquadrant.com>
2007-01-04 11:45 ` Re: Autovacuum not running in 8.2.0 Daniel Cristian Cruz <danielcristian@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 04:30 Autovacuum not running in 8.2.0 Ming <ming8080@gmail.com>
2007-01-04 10:33 ` Re: Autovacuum not running in 8.2.0 Simon Riggs <simon@2ndquadrant.com>
@ 2007-01-04 11:45 ` Daniel Cristian Cruz <danielcristian@gmail.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-04 04:30 Autovacuum not running in 8.2.0 Ming <ming8080@gmail.com>
@ 2007-01-05 01:15 ` 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