Re: Append with naive multiplexing of FDWs - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Append with naive multiplexing of FDWs
Date
Msg-id CA+hUKG+nnwmJMDuZJUt1VHnQUYS_Y97AiVJacRy4L8SZ7KGvZA@mail.gmail.com
Whole thread Raw
In response to Re: Append with naive multiplexing of FDWs  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Thu, Jan 16, 2020 at 9:41 AM Bruce Momjian <bruce@momjian.us> wrote:
> On Tue, Jan 14, 2020 at 02:37:48PM +0500, Ahsan Hadi wrote:
> > Summary
> > The patch is pretty good, it works well when there were little data back to
> > the parent node. The patch doesn’t provide parallel FDW scan, it ensures
> > that child nodes can send data to parent in parallel but  the parent can only
> > sequennly process the data from data nodes.
> >
> > Providing there is no performance degrdation for non FDW append queries,
> > I would recomend to consider this patch as an interim soluton while we are
> > waiting for parallel FDW scan.
>
> Wow, these are very impressive results!

+1

Thanks Ahsan and Movead.  Could you please confirm which patch set you tested?



pgsql-hackers by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: Duplicate Workers entries in some EXPLAIN plans
Next
From: Mahendra Singh Thalor
Date:
Subject: Re: [HACKERS] Block level parallel vacuum