Steps inside ExecEndGather

Поиск
Список
Период
Сортировка
От Kouhei Kaigai
Тема Steps inside ExecEndGather
Дата
Msg-id 9A28C8860F777E439AA12E8AEA7694F801245178@BPXM15GP.gisp.nec.co.jp
обсуждение исходный текст
Ответы Re: Steps inside ExecEndGather  (Kouhei Kaigai <kaigai@ak.jp.nec.com>)
Re: Steps inside ExecEndGather  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Hello,

I'm now trying to carry extra performance statistics on CustomScan
(like DMA transfer rate, execution time of GPU kernels, etc...)
from parallel workers to the leader process using the DSM segment
attached by the parallel-context.
We can require an arbitrary length of DSM using ExecCustomScanEstimate
hook by extension, then it looks leader/worker can share the DSM area.
However, we have a problem on this design.

Below is the implementation of ExecEndGather().
 void ExecEndGather(GatherState *node) {     ExecShutdownGather(node);     ExecFreeExprContext(&node->ps);
ExecClearTuple(node->ps.ps_ResultTupleSlot);    ExecEndNode(outerPlanState(node)); } 

It calls ExecShutdownGather() prior to the recursive call of ExecEndNode().
The DSM segment shall be released on this call, so child node cannot
reference the DSM at the time of ExecEndNode().

Is there some technical reason why parallel context needs to be released
prior to ExecEndNode() of the child nodes? Or, just convention of coding?

I think I'm not an only person who wants to use DSM of CustomScan to write
back something extra status of parallel workers.
How about an idea to move ExecShutdownGather() after the ExecEndNode()?

To avoid this problem, right now, I allocate an another DSM then inform
its handle to the parallel workers. This segment can be survived until
ExecEndCustomScan(), but not best effective way, of course.

Thanks,
--
NEC OSS Promotion Center / PG-Strom Project
KaiGai Kohei <kaigai@ak.jp.nec.com>



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: bit|varbit #, xor operator
Следующее
От: Haribabu Kommi
Дата:
Сообщение: Re: New SQL counter statistics view (pg_stat_sql)