Date: Wed, 15 Jan 2020 15:41:04 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Ahsan Hadi <ahsan.hadi@highgo.ca>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>,
	Robert Haas <robertmhaas@gmail.com>, thomas.munro@gmail.com,
	PostgreSQL-development <pgsql-hackers@postgresql.org>,
	Stephen Frost <sfrost@snowman.net>
Subject: Re: Append with naive multiplexing of FDWs
Message-ID: <20200115204104.GC7201@momjian.us>
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>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CA+9bhCK7chd0qx+mny+U9xaOs2FDNJ7RaxG4=9rpgT6oAKBgWA@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

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 +