Re: [PoC] Asynchronous execution again (which is not parallel) - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: [PoC] Asynchronous execution again (which is not parallel)
Date
Msg-id CAA4eK1JEqmVoZZSsMjer0c9L2aKXE6-gwpejLkUZtGhpJECRWQ@mail.gmail.com
Whole thread Raw
In response to Re: [PoC] Asynchronous execution again (which is not parallel)  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-hackers
On Wed, Dec 2, 2015 at 7:45 AM, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> wrote:
>
> Thank you for picking this up.
>
> At Tue, 1 Dec 2015 20:33:02 +0530, Amit Kapila <amit.kapila16@gmail.com> wrote in <CAA4eK1LBwj7heY8pxRmMCOLhuMFr81TLHck-+ByBFuUADgeu+A@mail.gmail.com>
> > On Mon, Nov 30, 2015 at 6:17 PM, Kyotaro HORIGUCHI <
> > horiguchi.kyotaro@lab.ntt.co.jp> wrote:
> > > ====== TODO or random thoughts, not restricted on this patch.
> > >
> > > - This patch doesn't contain planner part, it must be aware of
> > >   async execution in order that this can be  in effective.
> > >
> >
> > How will you decide whether sync-execution is cheaper than parallel
> > execution.  Do you have some specific cases in mind where async
> > execution will be more useful than parallel execution?
>
> Mmm.. Some confusion in wording? Sync-async is a discrimination
> about when to start execution of a node (and its
> descendents). Parallel-serial(sequential) is that of whether
> multiple nodes can execute simultaneously. Async execution
> premises parallel execution in any terms, bgworker or FDW.
>
> As I wrote in the previous mail, async execution reduces startup
> time of execution of parallel execution.
>

Could you please explain in more detail how async execution reduces
the startup time for parallel execution? Can you share the plans for
both the execution plans(with and without async execution), that might
help to understand the reason for same?


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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Gather node in OPTIMIZER_DEBUG output
Next
From: Noah Misch
Date:
Subject: Re: Rework the way multixact truncations work