Re: Union All View execution

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Ivan Novick <inovick(at)pivotal(dot)io>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Union All View execution
Date: 2015-10-15 07:08:32
Message-ID: CAA4eK1JQnoxVLeoaqjXv36v_pyXJeBANhgta6adV8Oft-wA5fg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Oct 15, 2015 at 11:33 AM, Ivan Novick <inovick(at)pivotal(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2015-10-15 07:32:12 Re: Parallel Seq Scan
Previous Message Victor Wagner 2015-10-15 07:07:40 Re: Patch: Implement failover on libpq connect level.