Re: Turning off HOT/Cleanup sometimes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Turning off HOT/Cleanup sometimes
Дата
Msg-id 31194.1410532230@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Turning off HOT/Cleanup sometimes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Turning off HOT/Cleanup sometimes  (Simon Riggs <simon@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Turning off HOT/Cleanup sometimes
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: expanded mode is still broken