Re: Union All View execution

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Union All View execution
Дата
Msg-id CAA4eK1JQnoxVLeoaqjXv36v_pyXJeBANhgta6adV8Oft-wA5fg@mail.gmail.com
обсуждение исходный текст
Ответ на Union All View execution  (Ivan Novick <inovick@pivotal.io>)
Список pgsql-hackers
On Thu, Oct 15, 2015 at 11:33 AM, Ivan Novick <inovick@pivotal.io> wrote:
Hi,

If we have two queries, Query A and Query B that both return same columns.

If we do Union All View will postgresql execute Query A and then Query B sequentially?

Does the work being discussed around parallel query have the potential to parallely execute both parts of a Union All View?


The work being currently done will not cover this case.  However,
each individual Query's involved in union could be run in parallel, if
they meet criterial for parallel query (like doesn't use parallel-unsafe
clauses).


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

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

Предыдущее
От: Victor Wagner
Дата:
Сообщение: Re: Patch: Implement failover on libpq connect level.
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Parallel Seq Scan