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 1l1jE9-0002sY-3D for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Jan 2021 05:06:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l1jE8-0001dc-02 for pgsql-hackers@arkaria.postgresql.org; Tue, 19 Jan 2021 05:06:48 +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 1l1jE7-0001cN-FA for pgsql-hackers@lists.postgresql.org; Tue, 19 Jan 2021 05:06:47 +0000 Received: from esa19.fujitsucc.c3s2.iphmx.com ([216.71.158.62]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l1jE4-0001Va-Ch for pgsql-hackers@postgresql.org; Tue, 19 Jan 2021 05:06:47 +0000 IronPort-SDR: 63Ms5UF2FBHa/lpOyFtsBtka20ICZqoz+kt1+UPpdQ2rQTlrv6Qy8qYCrLIVUt1SvU0DOBolOq TGCCtWJ+uHEWtUPS/o0bM2Cod/GEyUrAXxh+spQzV67nbHeY70ta5a0sm0P+vkpAY3uzzsW9W+ bM8tggcvVRDiB4uleFjZuN7lrexCxpHSTMk+0AmXhMciTjNBoUA64Zyf+s1EyNsc5deKyfcmmF VGNhL3O2MeIUJxrfwnmzFpQIRh1n3M/+omgDfhVMAkH665zqBnimDVHM06z9J4C31NBr6H3q0B 7rI= X-IronPort-AV: E=McAfee;i="6000,8403,9868"; a="24364336" X-IronPort-AV: E=Sophos;i="5.79,357,1602514800"; d="scan'208";a="24364336" Received: from mail-os2jpn01lp2056.outbound.protection.outlook.com (HELO JPN01-OS2-obe.outbound.protection.outlook.com) ([104.47.92.56]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 19 Jan 2021 14:06:40 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=aUEHPayYhNKoyv30SJjxYhYs/ZGaPkXfmNwqdbw4GDwPDQMd4bkP9LnZANLIhD5aEAMwmYm/odnMkQkBOoR7jtiDvkboN45sIiGnN/Ib2M9Jy2AMXWwpuJ8BsLCXB9njGdu0db778SL0/NpGeWLLwhJvRvCk+Ij5YahV+lm02YheWJGVnaNlqE5aBRK4U68q3NpRVb8Sf9Sa3pkxOIe1Hygi4hfWYjxuNz1PC0UuOU5Rh3DHi9UsR71zj1LPUqUU2hTwZfOpoQGL9p6d7unDN25fdukH2OamtG+WU1eCzUNXzvgdkyNA0QelK20oMtIJ3YFsgA+PL1+4JiNz8/PRfQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=AVNT2uRQKInB2r5y1H2aMiJlRNy0/VkcMcoUYWRDBrU=; b=QJKIRHq/is3xqiihmTU+cgGe3tp1FRILTaKtlHbIXqG6hKURVNDHpH4e8Pa5Md4v+7YnwAw8IzkJ+6nDvasCe8Z263ejTvObx+uyBe0Sjz1L8yy2ou1im0Ck7iqLFyi8p54bp0llSwIk4+qoPxmMdmHDa0AVEB31HIyrC1rs6mqfeiIgds2MfkB6DMFvXdm71Xmo6xVzUUFCcag/b2BEmka4uAJXzWy0F4SIJR08rHvFruHOZ55RUM5GlKPfWT5RKN6slmMdzPpJsCP5qz0iqD8ETSMHZi1LyYbImdpLEACn76e/ctx6IngbMxdUQ5ZZDzjWqX1EQ0if3RE6+dcshA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.onmicrosoft.com; s=selector2-fujitsu-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=AVNT2uRQKInB2r5y1H2aMiJlRNy0/VkcMcoUYWRDBrU=; b=bPMjvg2AJ+CRfoIzBMUNZYw8XBoqQs/3XNhogYKejlAA/9Wm2QXrojw8gosw3gSduw5fk53FV0OoAhphednl525TeocTYl//yNBCffFJDuHBzfWtQlnMoepCDM/43o/SGs3Fsy8k2gALWyM0ES3LCSv13rBzodlNjbwL0dPYfEc= Received: from TYAPR01MB2990.jpnprd01.prod.outlook.com (2603:1096:404:86::19) by TYCPR01MB6320.jpnprd01.prod.outlook.com (2603:1096:400:78::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3763.14; Tue, 19 Jan 2021 05:06:36 +0000 Received: from TYAPR01MB2990.jpnprd01.prod.outlook.com ([fe80::58eb:9fab:da6c:9e93]) by TYAPR01MB2990.jpnprd01.prod.outlook.com ([fe80::58eb:9fab:da6c:9e93%7]) with mapi id 15.20.3763.014; Tue, 19 Jan 2021 05:06:36 +0000 From: "tsunakawa.takay@fujitsu.com" To: 'Amit Langote' CC: Tomas Vondra , "Andrey V. Lepikhov" , Tomas Vondra , "pgsql-hackers@postgresql.org" Subject: RE: POC: postgres_fdw insert batching Thread-Topic: POC: postgres_fdw insert batching Thread-Index: AQHWTV48jxq7yejEtkyQCNOaaQ+gL6kASnQAgALcqICAinaJMIABSFyAgABMILCAMigKYIAA8OEAgADuC7CACa3M4IACN7QAgABx2BCAAM7DgIAFgfvQgAGK24CAAHVqIIAAjM6AgADD8xCAS0IkgIACChWAgABbwYCAADGkgIABAGmAgABCvACAABCbAIAAExKAgAF87oCAABIrMIAAC0OAgAQiqRCAALwSgIAAfUzwgAATzQCAABP0AIAAEhiAgAABX4A= Date: Tue, 19 Jan 2021 05:06:34 +0000 Message-ID: References: <20200628151002.7x5laxwpgvkyiu3q@development> <9808f343-410e-4441-9a10-42e14a1c6436@enterprisedb.com> <131a695b-9010-6751-9ea7-3dabe3555f8c@enterprisedb.com> <53187d73-05ad-90c8-b404-db5f250d3bb0@enterprisedb.com> <70d5f38f-1271-234e-c154-3c5c81b5bcf2@enterprisedb.com> <16fcfd4c-2d5e-67f7-fa69-9b5d119bac52@enterprisedb.com> In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=fujitsu.com; x-originating-ip: [218.44.52.176] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 5e9970cf-46b2-4107-fe85-08d8bc37ff54 x-ms-traffictypediagnostic: TYCPR01MB6320: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:9508; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: NW8T1qfNIF2n2mANsBxlROcJzJZvjikFkC0xkIW0KEucF01xBGtJM5j3ReottHAObKQqnUUNEE4FYdM7FAz6VRDV4DoD7nM6qGEuiUGXt0/xOApZYq2+iocExfXZ3cBTgbR/KfzmE+YQrYC9ya6EpdKkGH0q1zWj8OjJcbPpO/7WbwucyfCw5iGHHKe1/yt0nvhPxKmAYqKX3e5rYTehtsQfg7VcIoitrYm2p18w0j3aZeJm4uh5nIYFfhbFIrYRWWN/GzZckoO+DktDYqJZ9VyOM4Nmdka9kvneR8ItCsVNyvHoPa0YCOKhuYtPU/Y8gedUcbVgLiSeii3q1xQB5hle9COvL4MtfzLVg4ULRvsiVyqFgeZynkUxulMywSB8Q27OdVUqxESepFc4ayvrVXEiN7jL2Wl6eMGZR3XMLk/aCKFDHcMP19c2vvead+p1 x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYAPR01MB2990.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(396003)(376002)(366004)(136003)(346002)(39860400002)(316002)(26005)(478600001)(2906002)(8936002)(4744005)(86362001)(186003)(55016002)(9686003)(6916009)(71200400001)(85182001)(66476007)(4326008)(66946007)(66446008)(64756008)(83380400001)(66556008)(5660300002)(52536014)(6506007)(54906003)(76116006)(8676002)(33656002)(7696005)(777600001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?utf-8?B?N0ltWWhGNjF5aDlaTVljNkd3S2RaMGRJM1BVb0dFcyt0TlBlQXZnZ09VZklj?= =?utf-8?B?QUVScXg4NSt2cUI5TlFXYlE1UEZSOFV2ZUhrRG8vejdhK2JJUXJNSFpGYUdl?= =?utf-8?B?dTZtdjBzY0JidStZWTBPVXhMTHZ2NVhGVHl1MGJBWkJ2ZisxSFp1Ylc4MVMw?= =?utf-8?B?bGlYRENDOTVYMU1pSVBLdlNINllRWmdYaGhnbnRwa3ArQkZMcTVRY1l1VUs0?= =?utf-8?B?WXF4YlVrNWltblJxZ0QxMmxCcVl0eGZEWDVjMTJRT0ZDSXVNQnNtWjBNRVJO?= =?utf-8?B?WDVjbktDSkpTQ2xaSDNqM0RHNXc3MlV6YjhJUzZnRzNEZ2lsbGxHTUMzVGhy?= =?utf-8?B?cWJ5V25BWEs3dlkzaVRrYzdSV1dDWXJ3ZS9UMTF4czJabHMwOVRLbkp3cEdP?= =?utf-8?B?YlJyeHN5L2lBUWk2aTJUdEZxZk5sN3pTWXU5aUdOcXcwYmF3YWQxcGJmdmNG?= =?utf-8?B?ajdqOExGWE5JRFE5L2o1N3pBT1VHbmRlL2pqbFlGaStEcGJoNXVqSE1XbEVi?= =?utf-8?B?MjVJV1U0enRha01XelZWRzd1cFNmQ3ZUWmxUSzRxR2RMVmtCQkF5L2FNaXJP?= =?utf-8?B?S1J1L2VxOVVjWlJMUU5RM1kyTkE5b1l4bE4xWEZhQ0RhTWRmZWVpaXc2ZnJq?= =?utf-8?B?VXlBWEQ2Q0ZLTXpGWHBTZUlaWXNzR2NhaEZ3NjN6dWFCLzdHeVhNYjdQdCsx?= =?utf-8?B?cGowaUFZU1IyMVdXYzRPWWZmMXpDVTUwaFMrQ21yNGdteFFPR1Y3cklRbEUz?= =?utf-8?B?OXQvcUZuWDhVTWJtRnlrRzd5TjZvOGZML01HV1VTb1JKL2U0MnZEL2FOZXYr?= =?utf-8?B?WThGaXFHaU1yRW9SQnplOTRSVkRPT0RRT3RVVUkvUEs2WmVlZXNDUVBhR3VF?= =?utf-8?B?VGQwUFp1Q0hnRkJXRHpFZEg5V05hUlBKWlk0VnZ3NSthRFZZdGRWSk1pcmhR?= =?utf-8?B?QUo0cTF2ZEY4bzVlbW1KVDRpcWZkYjdpSjhUMVdCMFYvUHlkM01EU05DNmho?= =?utf-8?B?UEVGbkU4aXFxZW9qRkk4NmMvbkIwbUNFS21BK21HTDlMMmJhTzBCdGU4c2VQ?= =?utf-8?B?OU1NeEJqZ0JpOGVyWXNoaEdBeklmNkFoQ0p5QVYwTUJVOXRhZ0EwcGNVOUly?= =?utf-8?B?QXdlajJmQWVLUjUwL1ljQllZdlN5cW9RMG9SN2dYdDg3bHU1QzhrSjlOUDRt?= =?utf-8?B?bHAwTitBRUdoRVVPd1p4aXNqbllBRTc4U3lXN1UwMW5LM0RlOU9mK3RaWUo1?= =?utf-8?B?VjhycEVsN3ZVeG5VSGl5eHRxRnQ3R2Z0Q3BjNHJPSEQzYWtoU2VhMXZJcmZD?= =?utf-8?Q?IXlwR9aIWShGc=3D?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYAPR01MB2990.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 5e9970cf-46b2-4107-fe85-08d8bc37ff54 X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Jan 2021 05:06:36.1061 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: NncLPjEfqudR19WgHmG1QjvWDRRouH2CN8tMY6Abjmwq2ixPg6Tzq56GsP8c5wKztG/iSZ5ho6NBQQnJG5kWzc0EMuht2Mfc4Nj5n/eszLE= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCPR01MB6320 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk RnJvbTogQW1pdCBMYW5nb3RlIDxhbWl0bGFuZ290ZTA5QGdtYWlsLmNvbT4NCj4gSSBhcG9sb2dp emUgaW4gYWR2YW5jZSBmb3IgYmVpbmcgbWF5YmUgb3Zlcmx5IHBlZGFudGljLCBidXQgSSBub3Rp Y2VkDQo+IHRoYXQsIGluIEV4ZWNJbml0TW9kaWZ5VGFibGUoKSwgeW91IGRlY2lkZWQgdG8gcGxh Y2UgdGhlIGNhbGwgb3V0c2lkZQ0KPiB0aGUgbG9vcCB0aGF0IGdvZXMgb3ZlciByZXN1bHRSZWxh dGlvbnMgKHNob3duIGJlbG93KSwgYWx0aG91Z2ggbXkNCj4gaW50ZW50IHdhcyB0byBhc2sgdG8g cGxhY2UgaXQgbmV4dCB0byB0aGUgQmVnaW5Gb3JlaWduTW9kaWZ5KCkgaW4gdGhhdA0KPiBsb29w Lg0KDQpBY3R1YWxseSwgSSB0cmllZCB0byBkbyBpdCAoYWRkaW5nIHRoZSBHZXRNb2RpZnlCYXRj aFNpemUoKSBjYWxsIGFmdGVyIEJlZ2luRm9yZWlnbk1vZGlmeSgpKSwgYnV0IGl0IGZhaWxlZC4g IEJlY2F1c2UgcG9zdGdyZXNmZHdHZXRNb2RpZnlCYXRjaFNpemUoKSB3YW50cyB0byBrbm93IGlm IFJFVFVSTklORyBpcyBzcGVjaWZpZWQsIGFuZCBSZXN1bHRSZWxJbmZvLT5wcm9qZWN0UmV0dXJu aW5nIGlzIGNyZWF0ZWQgYWZ0ZXIgdGhlIGFib3ZlIHBhcnQuICBDb25zaWRlcmluZyB0aGUgY29u dGV4dCB3aGVyZSBHZXRNb2RpZnlCYXRjaFNpemUoKSBpbXBsZW1lbnRhdGlvbnMgbWF5IHdhbnQg dG8ga25vdyB0aGUgZW52aXJvbm1lbnQsIEkgcGxhY2VkIHRoZSBjYWxsIGFzIGxhdGUgYXMgcG9z c2libGUgaW4gdGhlIGluaXRpYWxpemF0aW9uIHBoYXNlLiAgQXMgZm9yIHRoZSBmdXR1cmUoPykg bXVsdGktdGFyZ2V0IERNTCBzdGF0ZW1lbnRzLCBJIHRoaW5rIHdlIGNhbiBjaGFuZ2UgdGhpcyB0 b2dldGhlciB3aXRoIG90aGVyIG1hbnkoPykgcGFydHMgdGhhdCBhc3N1bWUgYSBzaW5nbGUgdGFy Z2V0IHRhYmxlLg0KDQoNClJlZ2FyZHMNClRha2F5dWtpIFRzdW5ha2F3YQ0KDQo=