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 1o9IFP-00032P-4o for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Jul 2022 03:32: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 1o9IFO-0004YF-0Z for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Jul 2022 03:32:10 +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 1o9IFN-0004XB-Ez for pgsql-hackers@lists.postgresql.org; Thu, 07 Jul 2022 03:32:09 +0000 Received: from esa11.fujitsucc.c3s2.iphmx.com ([216.71.156.121]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o9IFJ-00005L-PY for pgsql-hackers@lists.postgresql.org; Thu, 07 Jul 2022 03:32:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1657164725; x=1688700725; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=xBEuZvNOclAbNmgx/aOONPi1EbMTqFytVc6NqDs9DeM=; b=RDOfSKpaQi0qB7CsdcgIlxdjvWlv9xYOo4jnkNY88QyNp+buejvrlGC8 PRL98QS9B3pbsYUChW82u4a3ebvZvi/IBctCa890Bk0mNAwNHi9i5N+DK PShAOpAEM5xirfW25s8cNCg7C79zmlEHieHxzvd2TKGCGDMjsXuOkS+/y Nz3QQhui+kuCDlvWSwT/7BRGOVBwfnBIRQFFYNDRdQsODbQFNKRHAqLSJ l1us5cjiPq6y0CrqluNvEMNkcMsWhQGf49+I4PBz470dlCYBh51ipgr5M d5sbviZIWRV2jUKnI3FKfVfAFJiQUzAeLxxvECDiQN9Njfk2ogsbkdCIQ Q==; X-IronPort-AV: E=McAfee;i="6400,9594,10400"; a="60177033" X-IronPort-AV: E=Sophos;i="5.92,251,1650898800"; d="scan'208";a="60177033" Received: from mail-os0jpn01lp2107.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.107]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 07 Jul 2022 12:32:01 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=BWUwRpn+9bsuFbfLBCiFfkOxhTcuiO+LTJxQC3SsR0/bK0b3oYVwCqZrroGOCvseDqbJSjBjOp2eIJ10VuCWED6+IlyCpFmynvZVQ///kEyj67QC3kJhuv97hmZt/XOd+7saQwpG/7VuFlk6BhbDPMnr+eo01JLzZw+qSHjP4PvsAFQ3cgynbxYt/nhkX94RXkdYwI70Y4KjNxv3XgnDYZXvvLB/zQlplGEuLsJGX5/vurcVX734RZVQ8qmXJuMA3uwDYAmYj+6P20LIeOE9NKnkrX6Mm/Mz9+WJhfFor5SavadUhEdTtcoNiTuy/ArxHJhB7qaR1A2/PYWD9RPjow== 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=xBEuZvNOclAbNmgx/aOONPi1EbMTqFytVc6NqDs9DeM=; b=MTjlJy5T3mvb6dBiEf4DpLYbetaeORF8mSVE6z9ge1PGidF4a3VdM2zzx0zwQVY7POlhq3u19lTyEARhn7ZJ734SHK7Xyzz7MZDJ3aDtftNfaTTZjqgw5wvAPJvUksrVjiug1lkpJYOMqEnzHaMy4HuWrLdUovtp2Dib1xS7yEoPvwsRP4nB0VvEIuSpo36cWBgRaH8Azg4btxvlGpYgyJV48s7YMuAMlq6aXgAb8X6Qw6pQm/TpWxYKfenMXdMF9oDq9za83KCNkI86pvtM6DFrcHMwvVPpN6NFBsCyOX9icAg9NJCGUixHihLTYt47S27J0iH8q1Pe2z7734OUrg== 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=xBEuZvNOclAbNmgx/aOONPi1EbMTqFytVc6NqDs9DeM=; b=WQSniVahTfdbbYHvn9Y/B0mohQR/8bCN2CVKxavXNRq9OH40+8a8uswdUGNr89gP+Zhy8WfBuBGbK/KsIEiu8898rzRAiru0vrh6mMKjjj8HmP9Sq8ZQjX/MTI/WERxjBzDsx9c3/8VUZL72h4MIhJ1GVWk3txDCpMjTpMej5OY= Received: from OSZPR01MB6310.jpnprd01.prod.outlook.com (2603:1096:604:f7::9) by OSAPR01MB4516.jpnprd01.prod.outlook.com (2603:1096:604:36::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5395.15; Thu, 7 Jul 2022 03:31:57 +0000 Received: from OSZPR01MB6310.jpnprd01.prod.outlook.com ([fe80::b1d0:e8c2:ba17:d49f]) by OSZPR01MB6310.jpnprd01.prod.outlook.com ([fe80::b1d0:e8c2:ba17:d49f%6]) with mapi id 15.20.5417.016; Thu, 7 Jul 2022 03:31:57 +0000 From: "shiy.fnst@fujitsu.com" To: "wangw.fnst@fujitsu.com" , Amit Kapila CC: Masahiko Sawada , Peter Smith , "houzj.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: AQHYSXX4LU7m/LcP/EyprXCDmGKXrazlvxQAgAkRYICACBI2gIABs50AgAA5UwCAApvIgIAFAGuAgAXc1wCAADTY0IALPdmAgAsABSCAB76ZAIAS+CyAgAAufICAAWQLgIABHxKAgAA3o4CAAeE3gIAJPr0AgAkxzACAAiJoAIAC0hUAgARvDICABQA2gIAAFvcAgAeBmICADieYcA== Date: Thu, 7 Jul 2022 03:31:57 +0000 Message-ID: References: In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9OTQ3YjdmMDAtMzRiMC00YWIyLTk5ODctYzQ5ZWY4NDAy?= =?utf-8?B?ZTZkO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZWNlMDUwX1NldERhdGU9MjAyMi0wNy0wN1QwMzozMDo1NFo7TVNJUF9MYWJl?= =?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-office365-filtering-correlation-id: a5aa02b3-2431-4dbb-35f3-08da5fc93efc x-ms-traffictypediagnostic: OSAPR01MB4516:EE_ x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: lMC3WwTMVWfkGCOdmEVe4glNS5x0OclVB5fVGvb4oitNFewQw2wM0KLwoEffYdHgbiLKPT0+ZRVkIYthxAZjuKb9yJbwZJ/1sj5D6ZDJ5Fky8eQ+fQX6lbEub+H4GaTMOFaP4fseLKEkFua6Aqymf+RBBE36mgBr8NhDAnHeQtbIJYtUJgwl+qIRInjGVTqxx7caeknTe2hLCh87N/0FZvM013H+ZWOX0mAFX8iz/Sz/fX2EZSNqBb07YLmUj8342bDx6vtKAd9nbRjuY4oOd98c7i0OJHsdomNGMxDWUf47WK15wNcxx7T2U4HTdZyYbZ+O+ZqiMwFZEwAXr6NbG+xeYt0lH0wBBQHklmzLcpSNrFFPX0Ixr0UcU05Li4xdSXOR1fNFbeBXJXf3lWLz6SXpFLDYCwKJIBUKB2AfVp09W2GHumyQbVoFxvqpHJXQ6iW5GtoV2H4I64dHQ/cyE1dAne8M0T42Dpj1rEd7uV719DVvZB1K8zrEWBepGHYK6EIM24qcwEqIBddMmLhHt9aRfZ7FdI343gRH8M44Pt1u2DC6j+TEDbqoWwAJoXSmfYqXID13E22xLrr6PTf8t1A4+SDehmzkpIYUhTdY0zr8rs/W7YU5OXaCSsIXwUJMwDSiSTkCIQROkALwb7qfsv9GJ3j5eVgrRU5ddoU7fOrXcbq0SC8JvAg4gQOwAx8UlyTPRKspykNUzrnoLAzZTKehcIPiA/1u6t9pIA1swLXTodPZ51aFjMXlpsWcld3w443X67xXHUc3+mjMj6PgHecn+o5RRFFVj1Tg4AyynGgRmjQOFr/8PmG1ftCYfap/ x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OSZPR01MB6310.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230016)(4636009)(396003)(376002)(346002)(136003)(39860400002)(366004)(38070700005)(5660300002)(8936002)(52536014)(7696005)(55016003)(2906002)(4326008)(122000001)(83380400001)(38100700002)(86362001)(71200400001)(8676002)(33656002)(478600001)(54906003)(110136005)(316002)(66446008)(66476007)(66946007)(76116006)(64756008)(186003)(66556008)(26005)(82960400001)(53546011)(41300700001)(9686003)(85182001)(6506007);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?NVl5Z0FJaXlOS1VTeXUrc1ROK3lnYVhmM0I3U1RSZGI4ZkZURkY4YkRqc2pP?= =?utf-8?B?M09UcTZ3QjBFM1l3RzVDM1J0dnJ2YUpTbk11eFp3NlZQWHZDeU9xWjMrdlVz?= =?utf-8?B?cjN4YzNibElUMmE2V1BGeUNQL3hzVWwyYm9ROWk3Zjh3aC9ycmpsd1pnNTJH?= =?utf-8?B?R0g0a3Y4THZGQ2pIN3huZVpoc0pwUE1yMmFOdVhuelBqOXlxV3hXV1FmbVZv?= =?utf-8?B?MTl2WG5WUnZPdkhUSCt3SGFEbWNtbE1sekRvaTlMNUdTeHBRcDVaQ1QyZ09n?= =?utf-8?B?aE9EQkNlZVhZV2E1dHlaMlR3QVhyVDhEMFAySU5LRFRxRGlxVUxLZ1NSeTlM?= =?utf-8?B?ak1YUGpIQjg3MTYxR3VQOWl4T2ZuSG5acnFXZ0IrTHNZdkdjODhQcUtycTFZ?= =?utf-8?B?VGMrUzlVT0J3d1p0S1FkaldVL0J4d0twRnVTZEpXRUdoYWQ3U3A0SFE5Q2tP?= =?utf-8?B?dGtzWEdYdzNyZmwvSlBXRFFBNUxBNFE3alRzREJ3Q3FjemZpVGZ2blhWVWlB?= =?utf-8?B?K01SaklRcTlNYXhxeDA5akVBZnhPMDJYZ3hBd1d4cnYvNlQ0eU1yUExZQm9m?= =?utf-8?B?L2ZhWFlWZ2ZRd09IblRidDRidkZiSEE4VVNJZDROdHNJeGM5WHdzL1ZVMVR0?= =?utf-8?B?VlhIdkl6T1d1TlJBek5mYkpEa0d4a1NwdlB5MytEUHVtTTI1RXlxbTd1WDYw?= =?utf-8?B?UmJBc0tjclUwblBkajNRemttNEo3bzNvSkltdGNKTjhKSG8wL2hlOUI0RDN6?= =?utf-8?B?RnZhQ0xEaXJVT3ZQZUdDbFNLTWRpL0hlWmpDbEVUUkpXZ2RGNVdOSmN3dWVS?= =?utf-8?B?VmtYR2dYRnJNcThLQ1JFcEJITVk5QncxUnFic3l4ZTFOWldDWXBEL2lQaVNp?= =?utf-8?B?cXRBRFkzVk9uQ2RuWEl4K3oreG9ZVGY5SDRDdEphdDZKRTR1M0pVMVhLYlpr?= =?utf-8?B?cURlUjhPdnMySHlLNWpIY1VXQzNGa0RiQjVVaXNWOXlvWXNTNi9XSlJoZG9y?= =?utf-8?B?ZlF5anNvbE13UGI1L2FCMk40enNNblpvaGh6U2d6cWp1ZzFLb3I1bFZNYmpW?= =?utf-8?B?WldwRm9FemZJT3VQS0ZPRFpQNzkzTHRuK3VsMHlBZ1FHSGs1WlJmOHhVVnJt?= =?utf-8?B?Q0NhM0YxTVRabjlBR0czcGZoaGtlUm9pc0xubVFleFg3YVZESzMwLzkra0F6?= =?utf-8?B?V1VEY1Qwa2ZGdjNYWG1MMGZsbzlORlEvVTZzdnlmR09wUUYrZFF1T25BYUxj?= =?utf-8?B?Q1VldUprNlpIbURrdTlkYURJYUhaQTgxYXhtd3VKU1Q1OHZ5emZCWGhPSVlU?= =?utf-8?B?UG5ZYlp3MjFwN05ja3ExWHVYZG93NVRhTGVzdFloeXNTVXBaWDh3Tm5tK2FR?= =?utf-8?B?d0YxOExRcW1MMnFRcTU1WjBGZ0g5bmpLY08yY1VON2ZnNjZzSlBKTllYYnU5?= =?utf-8?B?WjZaUVlnUTgrVVo0SGRQcFZvNTM5M1drV2tWZlo4NkhsYlI2UnNqMy9RVlFk?= =?utf-8?B?SDJBdkVCN2dSakhMcDdtS2dwb0JHeUhVWjFkZlltbUVrcWZBbzJLWkJ4a0h3?= =?utf-8?B?bnN3R3ljbGorVzFjWEo2MlVYNmJGQzNvcWlzeU1uR1pOSXVEU244YzlDZ2I2?= =?utf-8?B?SmlucTBrV3VueDBmZDN4dkpYYjExOFNMMmNZTFR4d3hZbTVYVFR0ZkZHTzVU?= =?utf-8?B?N1VORldmdm1BNmg1aU9leFcrVEF3RnpPMXk2VEI3VVVjR21QbGhXTG1GaHNL?= =?utf-8?B?eUREVGo5UHgySDd2OVZPNVVTeGhqQXRaMXFGU3QySVVOM1dQT0ZCWVNtdXlL?= =?utf-8?B?cDFPVmhpU1RUOU82SkhyK0xBZWpJZVJJZytwOFJZbzR6U0JRVndyVWorR3hx?= =?utf-8?B?bmpqaW9UUURGUFRyWVFJN2RmeGs4aURaRjVMc05vYlE4WXlxc0pZM0J3Ylln?= =?utf-8?B?S2o1R2U5WFVmUWhkSExSSTZLVFIvb0ZoZDRRb2doam1sdkg2emxQME5DbWg4?= =?utf-8?B?Nk4wbDRHcUFnTnB4RVBhc2EzamRlK00vOEk1anZxNWY4Vzk5Zk5EcUZ2anZ1?= =?utf-8?B?RTlzYXZQQyt6ekkzS3FhQnNwS3BxNm9EZ0VmVG8zdFRuKzZsUzM4aWlEMjdh?= =?utf-8?Q?yC3nd3Yclehe4WZ40YACLYh9L?= 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: OSZPR01MB6310.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: a5aa02b3-2431-4dbb-35f3-08da5fc93efc X-MS-Exchange-CrossTenant-originalarrivaltime: 07 Jul 2022 03:31:57.5659 (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: diQh1X4jCkBz1S/qu8X+OWJBXazeB8J/ioWZwDcszdkS4/L1NXKA7CmJS/nDguULRtBA1tAeHOgnFF0GIhTqAQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSAPR01MB4516 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVHVlLCBKdW4gMjgsIDIwMjIgMTE6MjIgQU0gV2FuZywgV2VpL+eOiyDlqIEgPHdhbmd3LmZu c3RAZnVqaXRzdS5jb20+IHdyb3RlOg0KPiANCj4gSSBhbHNvIGltcHJvdmVkIHBhdGNoZXMgYXMg c3VnZ2VzdGVkIGJ5IFBldGVyLXNhbiBpbiBbMV0gYW5kIFsyXS4NCj4gVGhhbmtzIGZvciBTaGkg WXUgdG8gaW1wcm92ZSB0aGUgcGF0Y2hlcyBieSBhZGRyZXNzaW5nIHRoZSBjb21tZW50cyBpbiBb Ml0uDQo+IA0KPiBBdHRhY2ggdGhlIG5ldyBwYXRjaGVzLg0KPiANCg0KVGhhbmtzIGZvciB1cGRh dGluZyB0aGUgcGF0Y2guDQoNCkhlcmUgYXJlIHNvbWUgY29tbWVudHMuDQoNCjAwMDEgcGF0Y2gN Cj09PT09PT09PT09PT09DQoxLg0KKwkvKiBDaGVjayBJZiB0aGVyZSBhcmUgZnJlZSB3b3JrZXIg c2xvdChzKSAqLw0KKwlMV0xvY2tBY3F1aXJlKExvZ2ljYWxSZXBXb3JrZXJMb2NrLCBMV19TSEFS RUQpOw0KDQpJIHRoaW5rICJDaGVjayBJZiIgc2hvdWxkIGJlICJDaGVjayBpZiIuDQoNCjAwMDMg cGF0Y2gNCj09PT09PT09PT09PT09DQoxLg0KU2hvdWxkIHdlIGNhbGwgYXBwbHlfYmd3b3JrZXJf cmVsYXRpb25fY2hlY2soKSBpbiBhcHBseV9oYW5kbGVfdHJ1bmNhdGUoKT8NCg0KMDAwNCBwYXRj aA0KPT09PT09PT09PT09PT0NCjEuDQpAQCAtMzkzMiw2ICszOTU4LDkgQEAgc3RhcnRfYXBwbHko WExvZ1JlY1B0ciBvcmlnaW5fc3RhcnRwb3MpDQogCX0NCiAJUEdfQ0FUQ0goKTsNCiAJew0KKwkJ LyogU2V0IHRoZSBmbGFnIHRoYXQgd2Ugd2lsbCByZXRyeSBsYXRlci4gKi8NCisJCXNldF9zdWJz Y3JpcHRpb25fcmV0cnkodHJ1ZSk7DQorDQogCQlpZiAoTXlTdWJzY3JpcHRpb24tPmRpc2FibGVv bmVycikNCiAJCQlEaXNhYmxlU3Vic2NyaXB0aW9uQW5kRXhpdCgpOw0KIAkJRWxzZQ0KDQpJIHRo aW5rIHdlIG5lZWQgdG8gZW1pdCB0aGUgZXJyb3IgYW5kIHJlY292ZXIgZnJvbSB0aGUgZXJyb3Ig c3RhdGUgYmVmb3JlDQpzZXR0aW5nIHRoZSByZXRyeSBmbGFnLCBsaWtlIHdoYXQgd2UgZG8gaW4g RGlzYWJsZVN1YnNjcmlwdGlvbkFuZEV4aXQoKS4NCk90aGVyd2lzZSBpZiBhbiBlcnJvciBpcyBk ZXRlY3RlZCB3aGVuIHNldHRpbmcgdGhlIHJldHJ5IGZsYWcsIHdlIHdvbid0IGdldCB0aGUNCmVy cm9yIG1lc3NhZ2UgcmVwb3J0ZWQgYnkgdGhlIGFwcGx5IHdvcmtlci4NCg0KUmVnYXJkcywNClNo aSB5dQ0K