Re: planner/optimizer question - Mailing list pgsql-performance

From Tom Lane
Subject Re: planner/optimizer question
Date
Msg-id 8881.1083374379@sss.pgh.pa.us
Whole thread Raw
In response to Re: planner/optimizer question  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: planner/optimizer question
List pgsql-performance
Manfred Koizar <mkoi-pg@aon.at> writes:
> Yes, the visible-to-all flag would be set as a by-product of an index
> scan, if the heap tuple is found to be visible to all active
> transactions.  This update is non-critical

Oh really?  I think you need to think harder about the transition
conditions.

Dead-to-all is reasonably safe to treat as a hint bit because *it does
not ever need to be undone*.  Visible-to-all does not have that
property.

            regards, tom lane

pgsql-performance by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: planner/optimizer question
Next
From: Tom Lane
Date:
Subject: Re: Insert only tables and vacuum performance