Postgres Pro
Downloads
Home   >   mailing lists

Re: Union All View execution - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Union All View execution
Date
Msg-id CAA4eK1JQnoxVLeoaqjXv36v_pyXJeBANhgta6adV8Oft-wA5fg@mail.gmail.com
Whole thread Raw
In response to Union All View execution  (Ivan Novick <inovick@pivotal.io>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Victor Wagner
Date:
Subject: Re: Patch: Implement failover on libpq connect level.
Next
From: Amit Kapila
Date:
Subject: Re: Parallel Seq Scan