From: Bruce Momjian <bruce@momjian.us>
To: Ahsan Hadi <ahsan.hadi@highgo.ca>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: thomas.munro@gmail.com, PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Stephen Frost <sfrost@snowman.net>
Subject: Re: Append with naive multiplexing of FDWs
Date: Wed, 15 Jan 2020 15:41:04 -0500
Message-ID: <20200115204104.GC7201@momjian.us> (raw)
In-Reply-To: <CA+9bhCK7chd0qx+mny+U9xaOs2FDNJ7RaxG4=9rpgT6oAKBgWA@mail.gmail.com>
References: <20191205181217.GA12895@momjian.us>
<CA+TgmoZc6HXhGJ+JSQ6ekcZT4Co-MhDH08wxVy3f9Dtt1TuOrg@mail.gmail.com>
<20191209171844.GA5192@momjian.us>
<20191212.214057.2013694839251103876.horikyota.ntt@gmail.com>
<CA+9bhCK7chd0qx+mny+U9xaOs2FDNJ7RaxG4=9rpgT6oAKBgWA@mail.gmail.com>
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!
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: bruce@momjian.us, ahsan.hadi@highgo.ca, horikyota.ntt@gmail.com, robertmhaas@gmail.com, sfrost@snowman.net
Subject: Re: Append with naive multiplexing of FDWs
In-Reply-To: <20200115204104.GC7201@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox