Re: pg_stat: last vacuum and analyze times are not being updated - v8.3.5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Steve Jones" <Steve(dot)Jones(at)codeweavers(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_stat: last vacuum and analyze times are not being updated - v8.3.5
Date: 2010-03-23 15:43:32
Message-ID: 28922.1269359012@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Steve Jones" <Steve(dot)Jones(at)codeweavers(dot)net> writes:
> Issue: the last_vacuum column is not
> being updated following a manual vacuum against a table or database.

It works for me in 8.3 ... as long as there already is a stats entry for
the table in question. You may be running into the pre-9.0 behavior
that the vacuum time update gets thrown away if there is no pre-existing
stats entry. If you vacuum twice, does the time of the second vacuum
show up?

http://archives.postgresql.org/pgsql-committers/2009-09/msg00062.php

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-03-23 16:26:46 Re: Disparity between 8.1.18 and 8.2.14 performance wise
Previous Message Dai, Tino 2010-03-23 15:22:13 Re: Disparity between 8.1.18 and 8.2.14 performance wise