Re: How does the planner execute unions?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: How does the planner execute unions?
Дата
Msg-id 20050826204554.GB11078@wolff.to
обсуждение исходный текст
Ответ на How does the planner execute unions?  (Chris Hoover <revoohc@gmail.com>)
Список pgsql-performance
On Fri, Aug 26, 2005 at 16:14:18 -0400,
  Chris Hoover <revoohc@gmail.com> wrote:
> Hopefully a quick question.
>
> In 7.3.4, how does the planner execute a query with union alls in it?
>
> Does it execute the unions serially, or does it launch a "thread" for
> each union (or maybe something else entirely).

Postgres doesn't have parallel execution of parts of queries. So it is
going to do one part followed by the other part.

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

Предыдущее
От: Chris Hoover
Дата:
Сообщение: How does the planner execute unions?
Следующее
От: Arjen van der Meijden
Дата:
Сообщение: Re: Inefficient queryplan for query with intersectable