| From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Ahsan Hadi <ahsan(dot)hadi(at)highgo(dot)ca>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net> |
| Subject: | Re: Append with naive multiplexing of FDWs |
| Date: | 2020-01-23 09:28:20 |
| Message-ID: | CA+hUKG+nnwmJMDuZJUt1VHnQUYS_Y97AiVJacRy4L8SZ7KGvZA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jan 16, 2020 at 9:41 AM Bruce Momjian <bruce(at)momjian(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mahendra Singh Thalor | 2020-01-23 10:02:34 | Re: [HACKERS] Block level parallel vacuum |
| Previous Message | Maciek Sakrejda | 2020-01-23 09:00:32 | Re: Duplicate Workers entries in some EXPLAIN plans |