Re: Autovacuum and OldestXmin - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Autovacuum and OldestXmin
Date
Msg-id 22797.1195798464@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum and OldestXmin  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Autovacuum and OldestXmin  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> That's a killer reason, I suppose. I was really trying to uncover what
> the thinking was, so we can document it. Having VACUUM ignore it
> completely seems wrong.

What you seem to be forgetting is that VACUUM is charged with cleaning
out LP_DEAD tuples, which HOT cannot do.  And the page header fields are
set (quite properly so) with HOT's interests in mind not VACUUM's.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Euler Taveira de Oliveira
Date:
Subject: Re: wrong behavior using to_char() again
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] possible to create multivalued index from xpath() results in 8.3?