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 1oY4ff-0000tt-Ct for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Sep 2022 12:05:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oY4fe-0006L0-7U for pgsql-hackers@arkaria.postgresql.org; Tue, 13 Sep 2022 12:05:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oY4fd-0006Kq-QN for pgsql-hackers@lists.postgresql.org; Tue, 13 Sep 2022 12:05:41 +0000 Received: from esa20.fujitsucc.c3s2.iphmx.com ([216.71.158.65]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oY4fa-0003MM-5X for pgsql-hackers@lists.postgresql.org; Tue, 13 Sep 2022 12:05:40 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1663070738; x=1694606738; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=4b4HYoHUuuD0C942Z7YIgzziz8ptd7Gps9+ShfMDR9A=; b=cthgY3xbHlCluvYERtkYrvlpLleyPVfoZD8lybT5B1kuRSq457XGlyKH 8hyy/sqZiZRhxIQh57lnJOHUQU/I8c6Srw7fh+4cK3Bc4TpS3Rknd8OrD OP5JDDt51Mp26XBd3Ja7TkHped89alb/CeP+ebSrhMYPq39qPQkz5Omrf UGB8GyDoQbxB+VmH/D8shluLxWAItkhbfB87/K/gMJB87v/N/S3L1wLfP 8pkkgdjOk2YXG6bU4+nr7K+JEVHjdjdNiP6W8GoO0ldE7RdHBo2UNuvAf kPv4gZhjM6bSdQENn0ZumNxMI3zevBPtttuWFasf9kL3DCUTsIvJhU0YY g==; X-IronPort-AV: E=McAfee;i="6500,9779,10468"; a="64935295" X-IronPort-AV: E=Sophos;i="5.93,312,1654527600"; d="scan'208";a="64935295" Received: from mail-tycjpn01lp2176.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.176]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Sep 2022 21:05:35 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=hGOt4fe8vPThA/85Rn5kVCK5BEp6Pon5uT6SbiiSNL7LSvMjOqWbijLyStW66NlSc/AApWqqxBhlML3JglscoVTu3x4FESWO0qRc7HORR4zy4J9mWP5yq3qZb8rPawndCIqwKXfnmGQZZBFBnyd+mtao3ZQBz03kYlvn9xpN4004dxPWBHukflyvLpF5kjV+mk5XjbcbUES6ouTAMhzUCleGeMy2ZPV46mejDyn9s8e6E9I6nQ5aaqE4a+jxYEa8ikgj7aSyQAN1m1Go5nRgIXNyN4u9L71zNXo/EPgHwV99fIhUQVNr165KKbaZ2gN8vvKg+yglBe5SvpnPLfh0Tw== 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-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=4b4HYoHUuuD0C942Z7YIgzziz8ptd7Gps9+ShfMDR9A=; b=Kpcb++8MswZt3C4BL5Jsgeg/VP1VczP4s6a3Zoa/7UdgzVyHFxFasn8VIjMINgWvx93ITYEWSKnVn+9OA/3vyDSi+6t1mdrpFrp/eBfjZArzExCBdjLz1l2/Dp5oQSHgL2n52BYzqD0xlpH/BH5JVw3Ex2FFYtWHMSy/TDmu11Lp/BbwtTcLbLyuXI3yZ4+tfhhUUHEcRERH+qkhMb89E2OQuqa59/Y7w99hCylT0hBBgymMD3hQpGxwH93fGiBeBVenMkHCBJsqAWDfyMxXWmcJLvVSeHPgXLDtR2ashF1dLjga6+vWYUipFih9q6vu2Yu1DgBw8vxhrBfIYfR7CA== 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 Received: from TYAPR01MB5866.jpnprd01.prod.outlook.com (2603:1096:404:8056::13) by TYWPR01MB8887.jpnprd01.prod.outlook.com (2603:1096:400:168::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5612.14; Tue, 13 Sep 2022 12:05:32 +0000 Received: from TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::a58d:5541:ebc8:3ef7]) by TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::a58d:5541:ebc8:3ef7%4]) with mapi id 15.20.5612.022; Tue, 13 Sep 2022 12:05:32 +0000 From: "kuroda.hayato@fujitsu.com" To: 'Amit Kapila' CC: "houzj.fnst@fujitsu.com" , "wangw.fnst@fujitsu.com" , Peter Smith , Dilip Kumar , Masahiko Sawada , "shiy.fnst@fujitsu.com" , PostgreSQL Hackers Subject: RE: Perform streaming logical transactions by background workers and parallel apply Thread-Topic: Perform streaming logical transactions by background workers and parallel apply Thread-Index: AQHYSXX67NoYEfdPmEWsDniEZU+Lb6zlvxQAgAkRYICACBI2gIABs50AgAA5UwCAApvIgIAFAGuAgAXc1wCAADa7gIALO/aAgAsRZICAB606AIAS+CyAgAAufICAAWQLgIABHxKAgAA3o4CAAeE3gIAJPr0AgAkxzACAAiJoAIAC0hUAgARvDICABQA2gIAAFvcAgAeBmICABO9ggIAJO+YAgABu1YCACQzpAIAJSy6AgAS+zICABq7mgIABSJUAgAAOtoCAACmRgIAB78qAgAqL+oCADJWRgIAGVm0AgAGAQICAAerMgIABYRWAgAgvEYCAAWyzgIAGSRYAgAFBqICAAFYagIABchmAgAGqzwCAATq/gIAFJCcAgAAGs4CACtsZ4IABkfWAgAAUS9A= Date: Tue, 13 Sep 2022 12:05:32 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfRW5hYmxlZD10cnVlOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJh?= =?utf-8?B?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjItMDktMTNUMTI6MDU6?= =?utf-8?B?MzBaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD1mOWZlNzdmZi04NTE4LTQyNzgt?= =?utf-8?B?OTMxNi02MmJmMDJiMDEzYjA7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?utf-8?B?MmFjLWFiNGQtM2IwZjRmZWNlMDUwX0NvbnRlbnRCaXRzPTA=?= authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TYAPR01MB5866:EE_|TYWPR01MB8887:EE_ x-ms-office365-filtering-correlation-id: 8825b0e0-3eac-4be6-dc0a-08da958041fc x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: k2DVqCWJ2mkKXo3tHv6aQU1jlHkg/TeVZT6sEw3mgyMZhdO19WtZYbPnCP2zmJsrgqx0yDuuQnCE08YqdBx65ki//oSYmtRDcUntG0IManbypP3UZG6Jk819HT2CEhZEEu03K8gbKhXSnTOE6bc3pGuhHRXaYx/H9EoPcAKB1lCnp2cfBiVuZASu905/u7gC4t/jraQPJ2JkvB8QzxE/ydj3PXZxE1VvRkaeMSPjr26nAFqWTAAADDF99FxeIOaFLBrkzcBrRmbqjvz0NcsVSUtvEvkw8uHQ7tp34PBVd3uY0xaWlyTBHrpg0dd8OZwpbI75uCwtWLEPBNaEH5+U/vLUJjH9QmF/KWd9t4kUakxoF3NHSMJ9Uba5FbemEWHdiPdPPuFLFSdgK+PhEuSRav4gChuUjljMEILz9XiQcfWvgbv6ppRnTGdrcUETX4WTf9jg8tPLaAx+dcvlJPeYi7UoTY9qeuV9zR27ZUNcKpzfwCzFf2J39IvGFKHsURdbcBZce75rQtBX79iBKJJEaEm2JWDLScg7dWnQLe8RXmj5OTXhW+hlfnq7zLmrAbyoseCpxYsjMKPDwUE38hKhRoKSnQv7CSggvOzB4u4ZKtX8UgScrafBELpxoGQuq4wDW+IZEQqkfplHJueoV3Bn3pI58Kic7LtRVlaWLFzlpg5laOyAoYUb327o66nNdA7XFfV5/iZrBlZtQQOzUqVzZGtu7ItOLrP2gcjuYM+092OzsmFRB2YD/+xYJ4XeiCXk9jyVmjLAVIPnOL8SgulWmFV/N2mKkXmTR5u6ZmIwj+o= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYAPR01MB5866.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230022)(4636009)(346002)(136003)(396003)(39860400002)(376002)(366004)(451199015)(1590799012)(66946007)(9686003)(55016003)(316002)(6916009)(2906002)(76116006)(8676002)(66446008)(64756008)(186003)(7696005)(85182001)(38070700005)(26005)(478600001)(83380400001)(33656002)(71200400001)(54906003)(41300700001)(38100700002)(86362001)(66476007)(6506007)(66556008)(122000001)(4326008)(82960400001)(5660300002)(52536014)(1580799009)(4744005)(8936002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?aHdIeVpNMXIyeFZDeGtCcms2SUtPNUl4aXdlZlhHSzMvblJucUFqc0RMaHor?= =?utf-8?B?RlBjUlB6WXN6UmFoSEpHYnc4RFp4MzN1NXI0eFg2S0loT2VDbEJuRlNzZEdX?= =?utf-8?B?azRZWTZxYndVN1RQR1hHdEdDSlpsdTRseGdZOXJVZ1JjSTVNVjkrclM0dlNZ?= =?utf-8?B?U0NjMS9MZGRnUkpnb2VUakltYUh2RnlRWEU3a1A2a0NKeUt6N0NDRTlIQjlF?= =?utf-8?B?QTJPeFNJeU5CRG03cWZyVm91STJlTXM2bGdCMlFZZjYwYjU1QVQzYW9mcktL?= =?utf-8?B?UkJEVlFNMXJoOU9FSmRnOEJkUGdzTW9xMTNsdVE0WkxvbjBpUTgrRWRHelN2?= =?utf-8?B?MnovNEo3Wlk4cEpQdEI3SW5ScTlxNldRd3huY3FDK05wMkpkZU4yVndyV0N5?= =?utf-8?B?L3ErYzJqbWFGTGJLMVIxS1pGakNvTUhSMXlaRG92VTJBd3hLZlBmOU5tdWc4?= =?utf-8?B?OEhFcHpadWFwYTBwTkFPeUZLMTBpamxyM3NpSTI0RmFveVBrdmxFZG5TMXZS?= =?utf-8?B?WG4yMWhlL2doM1RDUCthUk1UQW5nMEtidVRFRGQ3MDM1NVMwN0d0YzVySVBQ?= =?utf-8?B?YXVTQTQ4M3FSQVBNa2JQMEVOejFDQ2w4WU1ZRCtmWUhTRDBlUmozUXVEVXFZ?= =?utf-8?B?RlY3SlZKejI0Yk4xVmJyZmc2dENBMCt1VkJSYVo3Rm1IZUhqUkZxeW4vWUIr?= =?utf-8?B?QnFGQjhnbXNkcURURjZ5SlYwUFprQmc5TW5MSjcwd2NDNEhCbDRKcU9zWk9j?= =?utf-8?B?TzJwMzlxZmVUN0lWWGVLMklWSk4xOUNpcldjaG1FQkMvTEhGVjlJSk1vRVU5?= =?utf-8?B?Vy9zeTNmTGtrc0puSDBGOGI0c3o1dWppWHdUVjBOWEhVZktPMjkxM1kyUnlW?= =?utf-8?B?RXovUVBZUm5tRS9id3UwLzViN1drWnZVazRaZUtDeTRxYTBZRlZ1b1RCbk8y?= =?utf-8?B?Um1JWlFaWkRUdnZzUzh2VkExRzg1YUVHbzZuNkkvbnNnZFI5V3BrSFhYajh2?= =?utf-8?B?U1R3TFpwUWdyU3pDdWxQUUtHNmxlZzBtcHR2UjkzNVRJVnFZdHBmT1lsb2pq?= =?utf-8?B?RFVoWnd5c09nSVZFSXFRVXN2RTZUaTZOZlJseDkyeEwyMjNWUnFnekZ6ZjRt?= =?utf-8?B?ZHErWXJyL05xT3hvM1liYUo3RmxLbVRUREl2c0Nyc3FRQUJkWVk4QnlwdzF2?= =?utf-8?B?TE1lT2JyQ1lhc1N0elFYZnhkNWdkRjJ4MU0vbFZiZkRmUXNvdHBRc0IzL0tq?= =?utf-8?B?UHhPNCtTZnA3L0lPZTYwZWJrb1lWTHB2dnJnQXFVM3ZmSVVCaDFDNWMrZWZG?= =?utf-8?B?UjllaTFMSGhGdEZYMmZDNS9CcnNxdEVpdElZMXlZcDBpUHgrMWgybUxaZlo5?= =?utf-8?B?L1dLWTJyaWpFQW5zYnZaMU83cHJGQlhsM1dZbzhaT1ozMlNvR3I0S0VMVytp?= =?utf-8?B?YTN1SUEwbktTeGtBaU10UC8vNXdPcURwQXRjQUFQQ1V6cjU4V0k3eTlOVitm?= =?utf-8?B?Zkl0OGVWREkzYnR2WG52YXhJejNMSnBzdi9qWkltVlNkY1RPbU5XL1ZvSE1R?= =?utf-8?B?eVgyeFJ6Rm1TUVZ3TE4yZWN2ZlRWZy9RenZrRkJHVHZvZmlNQzdCSFJlUmZS?= =?utf-8?B?a0F3ZUNUY3JPUVZSVGVHOEJjZTFHZVNPT2lyelZ4YWJPWU1OcWNCb0RVVHJl?= =?utf-8?B?Vm9LSURMU25WOWQwMkkxdUptcFFKeW1JS09kVEJXYzRBb3hySzNHanU2ZUR0?= =?utf-8?B?UG1xdVlWL0xFZTlIVXZhQmJSRnFpSExjK0lFbGVmaGdKajhVbisrdXNLdHZP?= =?utf-8?B?VnVKYnRVdGoyTEtWNjV1Q2wrSHFwY3NKZmJ4d3dZeTBoMkN2amNSNCszdGRV?= =?utf-8?B?WnRrWmpUN0Y2ZzVWSUtnSmFBQlRnVHZNQWo0djd5d2NsZVJPWUhGYWdaeFN5?= =?utf-8?B?eHBzNkgvUW9Nc09XcDVLc0NvQk02aVBXUnVaYWhoRFdZTlFvakttblliWkYz?= =?utf-8?B?cFdkVXNtTlgyMzFjZWtFQzRiZ0pVcklBZGpQUEF4Qzdrc282cHpOUytPSDEv?= =?utf-8?B?TlljdTRvMWJ5dkVzVGp1eTd4RHRQWUpOWEpGbDNSazYwMDhhaVh5ZVluVm1p?= =?utf-8?B?cUY0NGVoeU4zZVE4V0FnaGhVcDd0cWN5N1ZTc2VRUVJyV1pVQlJ0REVUV3J1?= =?utf-8?B?aWc9PQ==?= 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: TYAPR01MB5866.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 8825b0e0-3eac-4be6-dc0a-08da958041fc X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Sep 2022 12:05:32.1632 (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: uCoilG4b1yFVyBimfTHJdPRVY/DUHhLPcjG7Pug9PvSvjQB9dprTKCB28ZYqCT059y9myOJB7a7gQs0LA/b4WHcfdYh6JsgmIMjQ7PVtmlo= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYWPR01MB8887 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksDQoNCj4gPiAwMS4gZmlsZW5hbWUNCj4gPiBUaGUgd29yZC1vcmRlcmluZyBvZiBmaWxlbmFt ZSBzZWVtcyBub3QgZ29vZA0KPiA+IGJlY2F1c2UgeW91IGRlZmluZWQgdGhlIG5ldyB3b3JrZXIg YXMgInBhcmFsbGVsIGFwcGx5IHdvcmtlciIuDQo+ID4NCj4gDQo+IEkgdGhpbmsgaW4gdGhlIGZ1 dHVyZSB3ZSBtYXkgaGF2ZSBtb3JlIGZpbGVzIGZvciBhcHBseSB3b3JrIChsaWtlDQo+IGFwcGx5 ZGRsLmMgZm9yIERETCBhcHBseSB3b3JrKSwgc28gaXQgc2VlbXMgb2theSB0byBuYW1lIGFsbCBh cHBseQ0KPiByZWxhdGVkIGZpbGVzIGluIGEgc2ltaWxhciB3YXkuDQoNCj4gPiBUaGF0IGZsYWcg aXMgc2V0IG9ubHkgd2hlbiBhbiBhcHBseSB3b3JrZXIgc3BpbGwgdGhlIHRyYW5zYWN0aW9uIHRv IHRoZSBkaXNrLg0KPiA+IEhvdyBhYm91dCAiaW5fc3RyZWFtZWRfdHJhbnNhY3Rpb24iIC0+ICJp bl9zcGlsbGVkX3RyYW5zYWN0aW9uIj8NCj4gPg0KPiANCj4gSXNuJ3QgdGhpcyBhbiBleGlzdGlu ZyB2YXJpYWJsZT8gSWYgc28sIGl0IGRvZXNuJ3Qgc2VlbSBsaWtlIGEgZ29vZA0KPiBpZGVhIHRv IGNoYW5nZSB0aGUgbmFtZSB1bmxlc3Mgd2UgYXJlIGNoYW5naW5nIGl0cyBtZWFuaW5nLg0KDQpC b3RoIG9mIHlvdSBzYWlkIGFyZSByZWFzb25hYmxlLiBUaGV5IGRvIG5vdCBoYXZlIHRvIGJlIG1v ZGlmaWVkLg0KDQoNCkJlc3QgUmVnYXJkcywNCkhheWF0byBLdXJvZGENCkZVSklUU1UgTElNSVRF RA0KDQo=