Re: wCTE: why not finish sub-updates at the end, not the beginning?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: wCTE: why not finish sub-updates at the end, not the beginning?
Дата
Msg-id 4D6776C2020000250003B026@gw.wicourts.gov
обсуждение исходный текст
Ответ на wCTE: why not finish sub-updates at the end, not the beginning?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: wCTE: why not finish sub-updates at the end, not the beginning?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Given that we've decided to run the modifying sub-queries all with
> the same command counter ID, they are logically executing "in
> parallel".
> Just run the main plan and let it pull tuples from the CTEs as
> needed.
On the face of it, that sounds like it has another benefit you
didn't mention -- it sounds like it's much more conducive to
allowing parallel processing, if (when?) we eventually move in that
direction.  It might even be a good case for an initial, limited
implementation.
-Kevin


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: wCTE: why not finish sub-updates at the end, not the beginning?
Следующее
От: Yeb Havinga
Дата:
Сообщение: Re: Sync Rep v17