Re: BUG #5722: vacuum full does not update last_vacuum statistics - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5722: vacuum full does not update last_vacuum statistics
Date
Msg-id 6540.1288015959@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5722: vacuum full does not update last_vacuum statistics  ("Jochen Erwied" <jochen@pgsql.erwied.eu>)
Responses Re: BUG #5722: vacuum full does not update last_vacuum statistics
List pgsql-bugs
"Jochen Erwied" <jochen@pgsql.erwied.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

pgsql-bugs by date:

Previous
From: "Jochen Erwied"
Date:
Subject: BUG #5722: vacuum full does not update last_vacuum statistics
Next
From: Tom Lane
Date:
Subject: Re: BUG #5722: vacuum full does not update last_vacuum statistics