Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNphX-0001ud-BF for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 03:56:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNphW-0002D6-8u for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 03:56:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNphW-0002Cz-21 for pgsql-hackers@lists.postgresql.org; Thu, 01 Oct 2020 03:56:14 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNphU-0004nh-01 for pgsql-hackers@lists.postgresql.org; Thu, 01 Oct 2020 03:56:13 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 57E2875A; Wed, 30 Sep 2020 23:56:09 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 30 Sep 2020 23:56:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=us1ZX3yBRtVbmhQucqBy1vu09Uc b7Rpk82G23iT4P90=; b=YCy8m2fqzc5CkT7K/r8FP0yMELDDOpb8Du6UP7GBXtL yd5iVEz+eIw4oN+ZhuKp3WA8ldv/7foc0+oR6hcN8XCrCwdyvODhs5dlzsCQoQQG BYKK6P8svx7tzi+zoVF4KBj5nO6DM4457wkcRIkl9YBbZvYZBQrxihZi1NNH7ckh a/dVtQB1+lXsdyx97MvT//5FzuS+hUfM80Fwg2oMLX7/SEGJqG4TcztbmKkw0otl G/dXcS8Xy8OecdKE0YVbTK3QIJcyssiGYYnbXoHqMhvfZwZelGZa1yxhTqpp3tPE r+udg99YH7MpCT8lMxyiTqDmdhtwCSC8Up0RH4GuHNA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=us1ZX3 yBRtVbmhQucqBy1vu09Ucb7Rpk82G23iT4P90=; b=gxfU1EDFyVbFOFokRi13iR uczkV/w+3dWGE2RF+Blcm4ppRBLDN+5pYcIjPa/lqo1C5efdQ7OyjxFKAXGPXAtR lovuYZXKEdKGCCZHlboSnr91TszL4T7KVOIxR+g9zV513P9M+m+UTic+JOA7F6mv ZbzNkyu8y6iyaoL17bndJy8Py1x/Su5a4NgAUDS+D4Xn34+fpQtdUmCPDI1NrE+o GND/sSeD6K+i1AVfXnQAoVdOOO+aHnulx4HlUAqehcS9iHTCS6Agl5OpWmSU/QjM McbEVRI3zuBuqaxX8LhUWpEAsJqRNqY99R500OSu3eF7kdTiypvfuI882fZ5xLIw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrfeefgdejlecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnh epvdegudeuhfdtueeltedtveejheehieevueeigeelteegleejleeiueeiheegvefhnecu kfhppeduuddurddutddvrddukedtrddukeehnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id E8CF33064686; Wed, 30 Sep 2020 23:56:05 -0400 (EDT) Date: Thu, 1 Oct 2020 12:56:02 +0900 From: Michael Paquier To: Kyotaro Horiguchi Cc: etsuro.fujita@gmail.com, pryzby@telsasoft.com, a.lepikhov@postgrespro.ru, movead.li@highgo.ca, pgsql-hackers@lists.postgresql.org Subject: Re: Asynchronous Append on postgres_fdw nodes. Message-ID: <20201001035602.GE8130@paquier.xyz> References: <20200928.103503.2700476870352492.horikyota.ntt@gmail.com> <20201001.111653.762470914964337419.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="vmttodhTwj0NAgWp" Content-Disposition: inline In-Reply-To: <20201001.111653.762470914964337419.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --vmttodhTwj0NAgWp Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Oct 01, 2020 at 11:16:53AM +0900, Kyotaro Horiguchi wrote: > Thanks. Since it starts all remote nodes before local ones, the > startup gain would be the shorter of the startup time of the fastest > remote and the time required for all local nodes. Plus remote > transfer gets asynchronous fetch gain. The patch fails to apply per the CF bot. For now, I have moved it to next CF, waiting on author. -- Michael --vmttodhTwj0NAgWp Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl91U1IACgkQnvQgOdby QH1Cjg/9Eva09MdjU17duAFGJywoxFVPqivRDYCUgBvkxi0yccbX3C5oxRhu8+8c L/axhsibgSoitP10UnU8wWBZHxk+ikuHXdoADbwe78KMp+pK0b02QysDaVW6OyfG 5ePkw5pNEtjGINfJBtr4cD4yNs0PoAsRxiV8rCh0we1APufLTz3eSqcgI219yjxu P5QdLcS+g1x5DuETTnukwZSdXcFM/OPLSEY4D4mH38Rrgwd6l2z7ns6ejQXj26iu LM06FSNBxnO/FlWQLTPri854oHmfErXyuh8d3j8+iF235MgYMxBNuve0KP3MFBuw KGSBMv8//Lz79AmMqZz8xJFWQUIsLSeOnYlfFrfQkNmxMzEBV34L6NhApCLYObRa n2Pd/czhBTHnRl8vp4Rv1PXpkvjk7xjB3eS4MniITNiTc0gJLEo/IAOtaAC3XVh3 c5hLMhaK81HHPhip32wZyeV40SRSCKLyziqfbUifMWJXQFW9SXq0TFydyka8erV5 lPpTYgUcj1wsWHiy5LmzTmstPpG7tYyMXBy77eESPjCp6rtp1Q1kuECTbpDo3rZU kLrFK7sSzED2kWUHKp2+0VGFUJiYcX7v8ejqRzh0PcbpnLPaygdBvbwBDFo0/Kcv h74Qkf3Kw7Z6KqvnvtYzhxI+llJne0WLeWYc4B0oLEenuwon7po= =FUsC -----END PGP SIGNATURE----- --vmttodhTwj0NAgWp--