Re: last_autovacuum & last_autoanalyze showing NULL

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Cc: <bnichols(at)ca(dot)afilias(dot)info>
Subject: Re: last_autovacuum & last_autoanalyze showing NULL
Date: 2010-08-25 13:45:19
Message-ID: 001001cb445b$c43d8570$4cb89050$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Truncate should not affect those values.
OK.

> Has your Postgres instance crashed or been restarted with immediate mode
since the last vacuum? This will cause the autovacuum information to be
null.
No, it's been up and running for almost a week. I even checked with "select
pg_postmaster_start_time()".

> Also, are you sure that autovacuum has processed these tables at least
once?
Yes, am very sure about this. As I told earlier, I keep tab on this
particular table and even noticed last autovacuum and last autoanalyze every
15 minutes (using cron job I write it to a file) with timestamp before.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dragos Valentin Moinescu 2010-08-25 13:49:32 8.2 "real-time" recovery
Previous Message Brad Nicholson 2010-08-25 12:36:33 Re: last_autovacuum & last_autoanalyze showing NULL