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 1pA21X-0003zg-LH for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Dec 2022 04:57:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pA21W-0002HX-Fe for pgsql-hackers@arkaria.postgresql.org; Tue, 27 Dec 2022 04:57:10 +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 1pA21W-0002Gg-4i for pgsql-hackers@lists.postgresql.org; Tue, 27 Dec 2022 04:57:10 +0000 Received: from esa1.fujitsucc.c3s2.iphmx.com ([68.232.152.245]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pA21S-0002Cd-1E for pgsql-hackers@lists.postgresql.org; Tue, 27 Dec 2022 04:57:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1672117026; x=1703653026; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=AeiYC5roy7Q4lZVT3+uJPHV8/98zEBdQ9P0TfHkgaxQ=; b=iW0mUPz2ma84a+RQuRBQfGAsFZGnhyeROxaOaDoeQUB3DEymMcuW78+n ioPTO89wc2SBNDj3R67B+kGAUYgKk8EBMMS+VhE15ysADQOvzBGIegcGY MuQObF0fsOR9IZfNKZUOjVivZ1vdwjaBBM/s7qgRuTdcIlEZHBmY8u2QA 3st8lElAq/a6SDO2R51mQncm6jlsL+UYfViB1XA3hxVeeNRtjO3HXkTqj r23S4tNNzKzKdOSmzZbERGq4dDUZIbS47cTWEvdqrfMnlpgPU3ajnB3nA 2/d55/HAnSegUx/jqyhH4mcjMxsFdMPSFvtHCKHAEp+f3651qioTxP+2O w==; X-IronPort-AV: E=McAfee;i="6500,9779,10572"; a="81593222" X-IronPort-AV: E=Sophos;i="5.96,277,1665414000"; d="scan'208";a="81593222" Received: from mail-os0jpn01lp2105.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.105]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 27 Dec 2022 13:57:04 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=TRBTCY73sO9JOS7tC3V/Avj/o0D9OCiIvJ1maS2scj86EBTQNGZJ2hQ0Emd1cyV0Emg0s4KC/RR0DveGg1Ch5BF0lmE8Yu3kfU4hwdRRAVNj3LKDu5lRTOR3an7ltm0nAAJOYwGc9UoiiNq49w8pPhQ92pLIcNUJ7AMiJobaQLzFyWLA3DVmmJKtCKKDMC8AFWoPlTEP3eJN71bCTbav1mwE3pNZq10XNyZSLqzP3hzfltLryq3Y32kFyMzeb0DWrVbSo2S/NDuUzR/A0f1SXGVxoYndCd+eYAF0mfBfC1O3Hboar0ecqAevbBX00J0PqtnpVnWv1zKgrTgcBXhYnQ== 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=AeiYC5roy7Q4lZVT3+uJPHV8/98zEBdQ9P0TfHkgaxQ=; b=OUWUwvawH4S/OPXXicNYnvVzBbM+TTgifIlmbadJlMvJ4VB7fRtROTgE7ZazESb8pPDUELiaVgPAYzT3u3aH8UpXGlWi4mspsEXh7LTzGDwKY09gXhmzQzqT+NNxWAqejiRUOQxQW+t6viGOgRttSKRhu5mX1nZh+3OrvhmDlWVrgmDrjXhUeVwU/xiWKrXWrnH8ZZ++hHgQFIpbdE3Ll0g5VfE8B/MNnopS+CU3KlV65gNFAOHZBcNV7I28b9dfAJhbjPQFZeu52R9nbt6VhL4EA5iAyz2gDPuG45Clh0vHUD2fWQsFIy0IEQ0W90ZpabPYmTbrGfbTPwmxuVlu9g== 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 OS3PR01MB6275.jpnprd01.prod.outlook.com (2603:1096:604:f1::8) by TYVPR01MB10749.jpnprd01.prod.outlook.com (2603:1096:400:2ae::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5944.16; Tue, 27 Dec 2022 04:57:00 +0000 Received: from OS3PR01MB6275.jpnprd01.prod.outlook.com ([fe80::212c:b8ab:a55a:2c69]) by OS3PR01MB6275.jpnprd01.prod.outlook.com ([fe80::212c:b8ab:a55a:2c69%9]) with mapi id 15.20.5944.016; Tue, 27 Dec 2022 04:57:00 +0000 From: "wangw.fnst@fujitsu.com" To: Masahiko Sawada , "houzj.fnst@fujitsu.com" CC: Amit Kapila , Peter Smith , Dilip Kumar , "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: AQHZD4glaZYxcS7PWkmy2G012OfTrq5uS4SAgAHPyoCAACQbgIAAHfaAgAGmKgCAAB5KAIADDzOAgAFWGwCAABIHgIAA+NgAgABKNQCAAf/xAIABKiIAgAA6H4CABGPrgIAAkTUAgAEKbtA= Date: Tue, 27 Dec 2022 04:57:00 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9YjMxOWMwYTAtMTI1Ni00ZWEzLTkyNzEtOGRjOTlkNDlj?= =?utf-8?B?NjAxO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX0NvbnRlbnRCaXRzPTA7TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5?= =?utf-8?B?LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfRW5hYmxlZD10cnVlO01TSVBfTGFi?= =?utf-8?B?ZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX01ldGhv?= =?utf-8?B?ZD1TdGFuZGFyZDtNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9OYW1lPUZVSklUU1UtUkVTVFJJQ1RFRO+/ou++gA==?= =?utf-8?B?776LO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX1NldERhdGU9MjAyMi0xMi0yN1QwNDo1NTo1OFo7TVNJUF9MYWJl?= =?utf-8?B?bF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfU2l0ZUlk?= =?utf-8?Q?=3Da19f121d-81e1-4858-a9d8-736e267fd4c7;?= 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: OS3PR01MB6275:EE_|TYVPR01MB10749:EE_ x-ms-office365-filtering-correlation-id: 07021088-b01f-434c-7673-08dae7c6ca20 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: d5gSuR7A46pFuK1cmBlo5LSiZIqqZcO4gjsogKwc5Qdp4XBZ0JOHM/JWRSWg6rdnXw9JkKR1ZegJ7XnRHK4zjcuokk9SGKZwaBdfDOlexZ8KX/jRrTyfsqTWrHazQf0Ti3ziFw01vA1LeYJXC91BN4lt2R7x+U0foOeXwKjeDU0ASqEm761cxE6oPVe4Qk1iRS/k8xOqDCkuGb9yApqG4vG/v8XTt1CLpfDlDcziJQ5xripX1cHHuDlU0OPHR8CY3WpSgLQuGlDs4u8U4S3U1RdhhTdHobvbt6OXWC7wAZOl7Hm+lYJ0e7jAlhS194cEEqU0WDRjhlli+9TjK6d5xy7TGJJbnMUusPYaA/HInwA5AKTN4g56oayOJqpTaZ0bLtEIZnftUcVT915YrVtlm32VCXbKKQMTbKo2H0+IvsmKg0iVrKvfQcDQvm017fc2e6zQgMboOZtatiOxuqNaZf8XKtDwZOrN/RVwIJ/vkJvdjpgjOKTi/F2cHOME66U1xtGMzr4CRO1EIVd0CdvTUxiJSiQxQxhbKs7RAOCJ9a9WEAV7/+VyC5x+rovEMyZBK3zHxJz9/gDBPsEaKMcYIIeYCYwqcOJQyB/ea5UemzqT34tvPo6D3qT8wH/sFDAt56IQlsUjRjvSc5buJ8Klyo6kMrevivQNhumf1u94hsBDFkf+v7Y8jhtRyIxjEPl0qi0me0m2anVgAO52j0T05TErrEXc0n6xFqRXk1ZhmroKBfoZTZBfE2dwbgv9qPt9mxwwfvLuxcc13/tV7xTfng== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS3PR01MB6275.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230022)(4636009)(39860400002)(346002)(366004)(376002)(396003)(136003)(1590799012)(451199015)(6636002)(83380400001)(110136005)(54906003)(45080400002)(33656002)(2906002)(4744005)(7696005)(85182001)(316002)(38070700005)(478600001)(966005)(82960400001)(186003)(122000001)(38100700002)(26005)(9686003)(6506007)(53546011)(71200400001)(55016003)(86362001)(8676002)(4326008)(64756008)(66946007)(76116006)(41300700001)(66476007)(66446008)(66556008)(1580799009)(52536014)(8936002)(5660300002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?Z2NQQ3FmYlFnRVQ1UUhEdWVYMGxEMmlPZEdDZkcyNlVqNm03bERSMDRQcDVL?= =?utf-8?B?SzhsY2hBQWdkbDNoLzk3eVZxOG1jSVVIWjZPZFJjZG9GcTNoTzVPWDViUCts?= =?utf-8?B?ZWhCbzNJekZCbTV5MDlocndqYnhSejlhOU5xTnhtcFBlVjhnTVRRcnh6VFM1?= =?utf-8?B?WHR0TjlHY2VScjZBV0NBQ3JuN1NQbmZxUno0azJXbmw0L2l2aVVGOVVMN1Jv?= =?utf-8?B?dWNXdTM2SGs4aHVKaEVyd3JBMk9wblVsaUJWemZtTE1RSHladWJDL1lMVFY1?= =?utf-8?B?T3JkTDdTYTZWWWxFak82TlJCOWxHRzlLQ0dwL1lXOWdISStTNXAyVkNiS21L?= =?utf-8?B?UEZHem52VEhHaVN1dTljWFZoTjVEMHNYdTJBT1JLc0h4QlFpMm9jZVVwZ0ox?= =?utf-8?B?L3AwSlNvdXpRZ3hyUWFNL1VYcDhubThucy9XRk4zY3hMOU1qOXVrSEtlOFNx?= =?utf-8?B?ak5Nck85ZEt1SVB6WFhhTStxY0RsQnd5OStzYVVzVnBpMmZEYitsVmNzOE02?= =?utf-8?B?aG16ZEhlOW5HTE5OQzc2Q3l2bFgrcFltQ2hYOFJQdElaekVZQmY4QlpxSnFE?= =?utf-8?B?bFVEeTRPMi9mRmN1UGZpaGpsM0tTWENmMUNHbjQvUTZvUFRKcDNiT1YyVktR?= =?utf-8?B?alY3RXh5L0JPOUViMklJdG00SkkvM3kwTXpBb3E0QkttOEpmZTlTYWJUdnVs?= =?utf-8?B?QzdCOW9UTW1YMHhybERYWVZKUHByZVVvOGRwM3RLa3p4cjV3RmJKNTR0MTNr?= =?utf-8?B?dVBZUkNlbFBXcG9HTkRLWkRDTXdFSnRFczJwK2ZuckFjVmMxTnR5amZYTEUx?= =?utf-8?B?VGtrK1Z2amJmVlYwRFFuUDBtUDEzM2tNQ0FKdUswZVA3cVRFcXhmY0hxeDhI?= =?utf-8?B?anFqNGVmdDhNVjBDeEVXaXY2dHN6bW5DYXdJQVhEb2xJVHBLUkNqSFNXMm5r?= =?utf-8?B?UUlyNEVKV2pYRS9BVUhvUFFaejdsakxxUENtdzRZVmtCajZpUUJmS1RyTHZn?= =?utf-8?B?Q09uV3Q1RXVtNGdTUHpHTzR5RUpva25jdmNPb1Fza0Q2SkpsNkswaWIvZGZq?= =?utf-8?B?M0prdVQ0eVp2VGk3eDkvblRzclpTMHJGbnpUSVh4TUxMOHlNeXZsN3BaZDdt?= =?utf-8?B?WjAxRStua2dmL0YyN3pPNUlVY0FEMzBqSnZMRUF6c0xEdE1vK3B0S0gzdkky?= =?utf-8?B?QklkSy9KQmRuNDIrZGJCWW9ocEZmVHNzYzI4Z2dHQ2pBdXFHTGVSOFlMMnV3?= =?utf-8?B?OWM4QVVnSkZzSTBVdEdlMHJOdkQ5QjU3ZnNWZmJyS0tpWUVUS2xpb01pVkFz?= =?utf-8?B?aVZHeW1VN21TNHRTckE4S0NEMmFzWW1CdzVPTzRxQjR1ekY5VmxxZkV3bWRY?= =?utf-8?B?emdVQUJ5b3dvN3hubWx2aGFpbnZXR1FQM1ZnZkdkcXk0R1FicnJ3QkEyNUFW?= =?utf-8?B?U2daQWxOc0xRN3U0QWMza3JoM0xZZmpEdGRBOUIyUGFPNzk3WWFSOFNwVlV1?= =?utf-8?B?c1VpOHlPV0FQWWNhTDI4RVp6QklrdzQ1Ung5Slp2YmorSVdGZ3h6NGJ0ZE1v?= =?utf-8?B?MzAyb0VUZGRWRUtTSStjeU9IOU5ranVSMnlaWmcvSTROR0lmdjRVNXlXMXNo?= =?utf-8?B?cEZoblE1RUZZS0dWSkpGMS93Qjh6YW9wUzRlUVJwMGxQQ1piaWxiSjV5T1lU?= =?utf-8?B?WkRDZE1mN0h0TGVWSDE5UHJQNkE5ZFo1dzdza253THJoZVVhS3FNM2xUVHhD?= =?utf-8?B?UnlyOERoWTdTS1Zkam11SUk4QUFkTTV6MmIrNFhZVmsyeGVSVjZ6Sit5TDF0?= =?utf-8?B?eFBtQmZTeC96bWJ3Q1ZWSWo4QitobGlhdGE2TjlWVmZKcGpnT2ppcHJVYW45?= =?utf-8?B?QVJVckZadlRBNVg1UTlQdXFKaGJBVVpvWDJFRVorOEkvR3cwd3NJNDhFYzVS?= =?utf-8?B?U1ZwQUluZjJRTlUrWDJ0aEh3VDA0OGNHdWVlMWFqNjRrb3JiOUcveWZRclI1?= =?utf-8?B?NXhGQTNlR3VpNlpzVldDQzdWMlo4ZVd4NWRvbGE1TnRVMjJJMjJlTGI1QzNV?= =?utf-8?B?aFNpMHpJMC9Zb0VYZW5sR2EvazVFUnpqb09FbTU4YWRNdUgvL1Q2VTZtZmxP?= =?utf-8?Q?uP+szGDBwHBPQaLJLv3pVLcJE?= 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: OS3PR01MB6275.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 07021088-b01f-434c-7673-08dae7c6ca20 X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Dec 2022 04:57:00.6543 (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: zIZDL2qDXcznE6M3NM5iQb9jCQsGDGL5GCfXZUNlmLYvk8CLBxDpOpZSMYzeFUSHGSNLYL/j5akxPjWDgpCV6A== X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYVPR01MB10749 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gTW9uLCBEZWMgMjYsIDIwMjIgMjE6MDIgUE0gTWFzYWhpa28gU2F3YWRhIDxzYXdhZGEubXNo a0BnbWFpbC5jb20+IHdyb3RlOg0KPiBUaGFuayB5b3UgZm9yIHVwZGF0aW5nIHRoZSBwYXRjaGVz LiBIZXJlIGFyZSBzb21lIGNvbW1lbnRzIGZvciAwMDAxDQo+IGFuZCAwMDAyIHBhdGNoZXM6DQoN ClRoYW5rcyBmb3IgeW91ciBjb21tZW50cy4NCg0KPiBJIHRoaW5rIGl0J2QgYmUgYmV0dGVyIHRv IHdyaXRlIGxvZ3Mgd2hlbiB0aGUgbGVhZGVyIGVudGVycyB0aGUNCj4gc2VyaWFsaXphdGlvbiBt b2RlLiBJdCB3b3VsZCBiZSBoZWxwZnVsIGZvciBpbnZlc3RpZ2F0aW5nIGlzc3Vlcy4NCg0KQWdy ZWUuIEFkZGVkIHRoZSBsb2cgYWJvdXQgdGhpcyBpbiB0aGUgZnVuY3Rpb24gcGFfc2VuZF9kYXRh KCkuDQoNCj4gLS0tDQo+ICtzdGF0aWMgaW5saW5lIGJvb2wNCj4gK2FtX2xlYWRlcl9hcHBseV93 b3JrZXIodm9pZCkNCj4gK3sNCj4gKyAgICAgICAgcmV0dXJuICghT2lkSXNWYWxpZChNeUxvZ2lj YWxSZXBXb3JrZXItPnJlbGlkKSAmJg0KPiArICAgICAgICAgICAgICAgICAgICAgICAgIWlzUGFy YWxsZWxBcHBseVdvcmtlcihNeUxvZ2ljYWxSZXBXb3JrZXIpKTsNCj4gK30NCj4gDQo+IEhvdyBh Ym91dCB1c2luZyAhYW1fdGFibGVzeW5jX3dvcmtlcigpIGluc3RlYWQgb2YNCj4gIU9pZElzVmFs aWQoTXlMb2dpY2FsUmVwV29ya2VyLT5yZWxpZCkgZm9yIGJldHRlciByZWFkYWJpbGl0eT8NCg0K QWdyZWUuIEltcHJvdmVkIHRoaXMgYXMgc3VnZ2VzdGVkLg0KDQpUaGUgbmV3IHBhdGNoIHNldCB3 YXMgYXR0YWNoZWQgaW4gWzFdLg0KDQpbMV0gLSBodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9t ZXNzYWdlLWlkL09TM1BSMDFNQjYyNzVCNjEwNzY3MTdFNENFOUUwNzlEMTlFRUQ5JTQwT1MzUFIw MU1CNjI3NS5qcG5wcmQwMS5wcm9kLm91dGxvb2suY29tDQoNClJlZ2FyZHMsDQpXYW5nIHdlaQ0K