Re: BUG #5722: vacuum full does not update last_vacuum statistics

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jochen Erwied" <jochen(at)pgsql(dot)erwied(dot)eu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5722: vacuum full does not update last_vacuum statistics
Date: 2010-10-25 14:12:39
Message-ID: 6540.1288015959@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Jochen Erwied" <jochen(at)pgsql(dot)erwied(dot)eu> writes:
> VACUUM FULL does not update statistics so display of pg_stat_user_tables is
> wrong. A normal VACUUM updates the relevant information.

Hmm. This is a definitional issue: what do we really mean by last_vacuum?
I'm inclined to think that the current behavior is reasonable. VACUUM
FULL is (still) not intended as a routine maintenance operation, and
the point of that column is to track routine maintenance operations.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jochen Erwied 2010-10-25 14:48:39 Re: BUG #5722: vacuum full does not update last_vacuum statistics
Previous Message Jochen Erwied 2010-10-25 12:42:24 BUG #5722: vacuum full does not update last_vacuum statistics