Re: Turning off HOT/Cleanup sometimes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Turning off HOT/Cleanup sometimes
Date
Msg-id 31194.1410532230@sss.pgh.pa.us
Whole thread Raw
In response to Re: Turning off HOT/Cleanup sometimes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Turning off HOT/Cleanup sometimes  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
I wrote:
> I think there's another way to think about it: what about saying that
> the query's target relation(s) are subject to pruning, while others
> are not?  Then you do not need an executor flag, you just need to
> look at the estate->es_result_relations array (or maybe even only at
> estate->es_result_relation_info).

After a little bit I remembered there was already a function for this.
So specifically, I'd suggest using ExecRelationIsTargetRelation()
to decide whether to mark the scan as requiring pruning.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Turning off HOT/Cleanup sometimes
Next
From: Stephen Frost
Date:
Subject: Re: expanded mode is still broken