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 1oLbC7-0008EF-K9 for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Aug 2022 02:11:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLbC4-0000Ik-KR for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Aug 2022 02:11:36 +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 1oLbC3-0000IL-Qy for pgsql-hackers@lists.postgresql.org; Wed, 10 Aug 2022 02:11:36 +0000 Received: from esa6.fujitsucc.c3s2.iphmx.com ([68.232.159.83]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oLbBy-0004TL-GQ for pgsql-hackers@lists.postgresql.org; Wed, 10 Aug 2022 02:11:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1660097490; x=1691633490; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=9gfN5BUwTTZLC0TcefhzdIGmA+s7uCUhqoX3kpbuQ78=; b=wIHQ0ZsJlqr4lG99cAwTlS/7k19rLYDV7N6OjMIGfuLlRWHJ9gW0Y++g MpnASyYPxgClVTHucsMXW/keQuMkdCJX59zbv6VW5l5dVwkbToQIEGEE+ 7UeCF7pAL1uIIaE1Kx34lcixlWZUTjY0VOCGlgQlz5FqeONWFuTvMKj7k 5OnLSHnXwk7v5dIW+Bj+wWwvUcyCzcpEqkHgGwKM3d3FUALj4zQg/FtPN hEmQ5qPKGxNT9sRUGP9SVclJUixWUzcLtEhnfWzPnr6MtGsWpllikxk14 5BGADqBv/AY7BGQtzXZ2uctsuMDUmOSLcbuqCI9TiwwhH8Z2cFN5TXaRI w==; X-IronPort-AV: E=McAfee;i="6400,9594,10434"; a="62494718" X-IronPort-AV: E=Sophos;i="5.93,225,1654527600"; d="scan'208";a="62494718" Received: from mail-os0jpn01lp2113.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.113]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 10 Aug 2022 11:11:25 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=VK4e2azEU3UuSrtVgnKHbdztvPdulw3OQYMQ68q4KcK4Edn+4QP2ePrpvZlCdVHvjdzVstIl+bF74C/1VbNMAxHQRS1OWiSFkBSi3L0pG3H4W1KQBKkFWIN+3yRs6lq4xhCBJIwHkdRDXcO61Fklyw/vVFwQYrBN0m8EGb/qe9Z/u+vxC6WESbi+lE2ZqHNuPR4vn/PU2HTJ+oe0E19fTonIo71D+Q+u03u/LyAsdxhJHdfAd/iFtJqHD1vloNdc4dTusj+yiCHyl+dF2LI84Fc/udnWxE1d9Taj6Pc7kb4XVF7/IiAqYH2vc9+5HzYaFc6DbUwXTguc2wOJxDpPiA== 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=9gfN5BUwTTZLC0TcefhzdIGmA+s7uCUhqoX3kpbuQ78=; b=QS8u4HUf0z111oyODu4tmHhsfeZ0oWn0LmErFvkBW2vLd88gujBtdbnENb27alXlJ0xxUK3gLZ1TC5DaPNjzbanSLYuBG9+GK5zl7pUjm1BqIxk1TsdA7fFFBiG5Ml1cCOV3+e1J3qR6GilouXTZxPRQFTK5GYNeYhXNmq8qCiLqKBMIgUqSqCzhjYnWQ4YQS0aieZOfYjnGVjvyIbc+FjRaV5cB7dBpGZbSl9WLMusTmIk97pQjUVGMs3f3nHKjeMb+GLsXIk6bC4XldR0dOaXmO3qrCsPgeML8TI5EjahyYhtY7/pxc7brPQLoxvy6fKlxhsFZjZF/Q1mTfhxFBA== 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 TY2PR01MB4505.jpnprd01.prod.outlook.com (2603:1096:404:10e::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5504.17; Wed, 10 Aug 2022 02:11:21 +0000 Received: from TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::45f2:93fc:60c8:2c1e]) by TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::45f2:93fc:60c8:2c1e%3]) with mapi id 15.20.5525.011; Wed, 10 Aug 2022 02:11:21 +0000 From: "kuroda.hayato@fujitsu.com" To: "wangw.fnst@fujitsu.com" CC: Dilip Kumar , Peter Smith , Masahiko Sawada , "shiy.fnst@fujitsu.com" , PostgreSQL Hackers , Amit Kapila , "houzj.fnst@fujitsu.com" 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+oCAB/a9cIABLFQA Date: Wed, 10 Aug 2022 02:11:21 +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?NTBfQWN0aW9uSWQ9OGIzN2M3ZTMtZmI0NS00YjgxLTg1MTAtY2Y2YzQ4NWNl?= =?utf-8?B?OWMyO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZWNlMDUwX1NldERhdGU9MjAyMi0wOC0wNFQwNjozNDoxNVo7TVNJUF9MYWJl?= =?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: 73be0f2c-c6e2-4a84-e836-08da7a759e79 x-ms-traffictypediagnostic: TY2PR01MB4505:EE_ x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: uCy0YE3t1USP0S+bZXkguZMK8rAuEM9APTOancoJZ5BWKQLvpIzqF9C5S/pLuAWmp/KVLVcIOa8jZaRIljyPRVD8VpF6TWgzsjF5P9dRLsjja2RYDcsww1R2qIOZzG+C6IWGbL4WSLSEANtmpAgGxZKPlTgDemq5/+zshRwwegWz/QKndkQIJd/wjfgy/feRoBG8eFlgLEp3GNkkBVdqypfZI5HSEJ//1XTWMd4zPVGXh5iamGdkrvlrhczwnVuFAh455f0rd1wISBa04+tmkl9XVAKuTxBf4b+0BA/Cv3x1aNHphbLKR9OyZqq48/GKgmR1AZ9Rlvxzj8wztvOdZ0Rkv7Ti0w+elzkDii4lXVUuxS7lAHP87UdI8p3V+w9F4IqEad97lmyDAhiL4EvM0eN7HJrpzQ1T76aUTFJZRNmqti3ogJsv/4glaC6QsCDzqdSM3w+oHzHK5lMwhOx/Ckx3SRM164MbYU5f3aLG833AbkdSwW3s7ZS4vsyD1PrTF9uO9oZ9waJmyujkLFO/KNjp8+dj7Z7c70Y+KZfPQUIg7cFdCgA1seO65hnR5tAMxAGgoANxQPWypmts9zA/bzHR99kxLqyowm9ARc0jF65YUX02s2fQmvjclkQEviMUz7KVAax8qH0S7oPu8MLf4wUjVLOypaNRADRmBYIOS2waaXVBxaRGpcOQ2yziv5KpaSzHPzjTP7K66JSu4ndiQ6MRjpHjkRCiIyuWp2a3lgwuz/3GxpnHZ2WT0Xpulj7UJZqSvFsm5NgHd7DxCqpgWdsmXCDGwmqKkepqB703zIHSv3tKYoV77k9y9vDPmHIL 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:(13230016)(4636009)(39860400002)(366004)(376002)(396003)(136003)(346002)(5660300002)(86362001)(38070700005)(2906002)(66556008)(66946007)(66476007)(64756008)(38100700002)(66446008)(8676002)(9686003)(7696005)(6636002)(4326008)(6506007)(76116006)(26005)(478600001)(54906003)(316002)(55016003)(82960400001)(71200400001)(41300700001)(107886003)(122000001)(186003)(8936002)(85182001)(83380400001)(52536014)(6862004)(33656002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?dUwvVUJCRlJWT21xeHlUV1JrTGpnMXl1V0xzNVQ4TUZFZEZsVE5rcDRnczF4?= =?utf-8?B?V1E1U3UwajFnMzVOd0NDS21rVG9tMkR5VGtQVWY0RGZrYmlreFBxYWxqSThD?= =?utf-8?B?SkQ2L3Q2WXNlakVaK1ZqbDRyYmZPeFA5c21wWnJpdnp6OGhuNTl4T0ZlTlNT?= =?utf-8?B?WWxKaVprdG1LWDEzRXY0dnBSUFUzQW5DT1Y0ZFUyN1RvSjV3NklTam9vMlRO?= =?utf-8?B?cy9qTkpBWVQ2aFVna2VEVFlKL0VLV1NBckZaWmlEV1Q1Uy9ldHNYdE9WNStX?= =?utf-8?B?K0Y1L000Y0hGNUxUU0dGMDNGbFNKaFd4c0FBaVFsY1VVTjFxWTdqb1Fid21Z?= =?utf-8?B?UGhocVllQm1iRTE0K2xxWXdzcHBtaE4vR0NYaGwvdWRjVmVEZlh2V2lBa3Z3?= =?utf-8?B?aldaY0NYV2VqRWhyWURjWStpUVR5dG1JM0RMNW1wYjc4dXlkcUtpTG9xdVg4?= =?utf-8?B?MGxLSnZpTFBhUUNGLzZIbkZBZ3drdWRPUGNsUWxLVEFQUVNzZ29YM0ttTm1a?= =?utf-8?B?a1QrUVpJYUhJa2lqei9ITnZRN1ViNlIveFZ4Q1daWnhiVmJKbEt4akpMdjZk?= =?utf-8?B?bjRtL2lRSkpKMi90aDVrekR5eTRDczZ3VnpyU0U2MmlPMVhhRTV3dzVFaFRK?= =?utf-8?B?NVExTytNRGFLaDhrN0h3ZnRYZnB3V3BGcm9TUS9NT2hXV0I5UTMzdCtmeFBD?= =?utf-8?B?Z29CZ2xXYUYxNklYdUx5Z053V251VjdmRk5QOU8wSzRKUXg3QU1acnlhNEJI?= =?utf-8?B?bHJHZ0xsQ21aZ2pONHByNkF4S3ArcitoKy9ibHpkL2pKcmtiNkoxZUNjcjcx?= =?utf-8?B?eDhyMTVsNStaWFJVTDc0eTJodFBGR0wwRnRXYzNYeEx1cnluSUVqb2RoYURa?= =?utf-8?B?VkQvZjVabFZzUWpqOG5aRXdSL05FMXBsRGJNQ2RNdXZ6cjB5Z2UzWCtyWHU1?= =?utf-8?B?K0JjZHVVZ0FvVTVtSndyUkZTWnhCbjVKbUJ0ekR4NzlLRVExc1VsaEdIcVBw?= =?utf-8?B?YTR2T2hSWTAvQmFnb2FFQmV1ckwwdy9oVWpUeFExdWxVVVgxaFpZcTh4R3Fh?= =?utf-8?B?MmtnRVRaVHdRV0lrZ05EbVpTZ2tuWWJhQW91RVFtbUc2c2dveGN5dTZmMUxk?= =?utf-8?B?LzQ2bHgwMS9wWW9NTncrNzlPcFpqc3g1c3JpeVBBazVmNEZBTis2c3JwZDRB?= =?utf-8?B?TGJaSktGZVJRNEFYa1VmdzdRc0Vrdzh0c3BMT09USHBvWUhiM21yMk1iUHJw?= =?utf-8?B?cFlLMkNLUCtFZzhjOENsdXByYlBtaVBSWXVHb29FZ3YyTjgyNnFKQngzdjFB?= =?utf-8?B?bE83bEQ0RzJWVHdLbDBPejA3QmJqME5rZk9HYVVpbjJ2azJDcGozbldxQ3Fo?= =?utf-8?B?L2prUmNyZzFtdWVmTi9SNy9kUkFZaHFidFhrS0NWMUtXN203MUJCM00zUTdY?= =?utf-8?B?SnlSaWJMVlMyQ1VqV3VaNHRQVG1xeHc2RlphcS9lK3VpT1VteUttZVFEWEVp?= =?utf-8?B?RWI2MGhqL042djV0aUxKUE4yb1JYcGp0SExaTU12RXVGTExRR21Wd3JIWjVT?= =?utf-8?B?NTBWNFhpa3IvSjZ1RUdoUHJ5RU1raVR5NVRnU0J6NkI4aThmWDY4YzJoY0xO?= =?utf-8?B?OEtWWHhhMEdLOTBCbWwrQ0wzZnBLT1c1YWFGKzMvVzhXQklNak5HRzNGdy9a?= =?utf-8?B?cGVvOXIyMGlaU1FIeEgwNkhjY2dtdjFSbEJYcng0citKbUQrTjdHMUozTmxC?= =?utf-8?B?NThnczJwWjJXSmV3KzlxL1VvTFkySzZqT2k2ejc0eUNkK0l1OTc2WlVhU0hE?= =?utf-8?B?R2lBZUhHRFNZemVmYTVpSkJxS2xmNDRDVFZsWWxlQXk0cjQvdEZNeHFxQllz?= =?utf-8?B?RGM4OE1TSGhYNjh4aGkwbElsOHJiZWxSWW9haEkxTmU3ejZaL01BYmhCbGVw?= =?utf-8?B?NUd4d3JOWkRsTVhRSDQyN2pucXI0QVZZOWNUMmJ5Mml5d05aSUhaVWN3QjVj?= =?utf-8?B?d2RRbnlsUFF4dG45bGFlY1Bsa3Z6R0FNblB2eXgzb1ZFK1Q1UHlhcCtQRCtS?= =?utf-8?B?c0xvUExpRGRDdXg3QUJITXl4eUxBTjlaeExSN2g5VGxtWVlqTkNVamZGT2VY?= =?utf-8?B?YllXK3BxVFpWdVVhMEpFN0Q4bVpvR0pyWlovSnFwYmxBYW9PQW53SmR6NDM5?= =?utf-8?B?NkE9PQ==?= 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: 73be0f2c-c6e2-4a84-e836-08da7a759e79 X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Aug 2022 02:11:21.4273 (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: LlatVF5FI1iejP19I6kbCbD+oT1f7DFz6kPV4nJUEZA/hntZNuV/JBMFAVM84wSfiNJK5Nn0rGw5k0TKli2zN2v1H5q/JpugZX5Imm2pQsM= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY2PR01MB4505 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGkgV2FuZywNCg0KPiA2LmENCj4gDQo+IEl0IHNlZW1zIHRoYXQgdGhlIHVwcGVyIGxpbmUgcmVw cmVzZW50cyB0aGUgYXBwbHkgYmFja2dyb3VuZCB3b3JrZXIsIGJ1dCBJIHRoaW5rDQo+IGxhc3Rf bXNnX3NlbmRfdGltZSBhbmQgbGFzdF9tc2dfcmVjZWlwdF90aW1lIHNob3VsZCBiZSBudWxsLg0K PiBJcyBpdCBsaWtlIGluaXRpYWxpemF0aW9uIG1pc3Rha2U/DQoNCkkgY2hlY2tlZCBhZ2FpbiBh Ym91dCB0aGUgaXNzdWUuDQoNCkF0dHJpYnV0ZXMgd29ya2VyLT5sYXN0X3NlbmRfdGltZSwgd29y a2VyLT5sYXN0X3JlY3ZfdGltZSwgYW5kIHdvcmtlci0+cmVwbHlfdGltZQ0KYXJlIGluaXRpYWxp emVkIGluIGxvZ2ljYWxyZXBfd29ya2VyX2xhdW5jaCgpOg0KDQpgYGANCi4uLg0KCVRJTUVTVEFN UF9OT0JFR0lOKHdvcmtlci0+bGFzdF9zZW5kX3RpbWUpOw0KCVRJTUVTVEFNUF9OT0JFR0lOKHdv cmtlci0+bGFzdF9yZWN2X3RpbWUpOw0KCXdvcmtlci0+cmVwbHlfbHNuID0gSW52YWxpZFhMb2dS ZWNQdHI7DQoJVElNRVNUQU1QX05PQkVHSU4od29ya2VyLT5yZXBseV90aW1lKTsNCi4uLg0KYGBg DQoNCkFuZCB0aGUgbWFjcm8gaXMgZGVmaW5lZCBpbiB0aW1lc3RhbXAuaCwgYW5kIGl0IHNlZW1z IHRoYXQgdGhlIHZhbHVlcyBhcmUgaW5pdGlhbGl6ZWQgYXMgUEdfSU5UNjRfTUlOLg0KDQpgYGAN CiNkZWZpbmUgRFRfTk9CRUdJTgkJUEdfSU5UNjRfTUlODQojZGVmaW5lIERUX05PRU5ECQlQR19J TlQ2NF9NQVgNCg0KI2RlZmluZSBUSU1FU1RBTVBfTk9CRUdJTihqKQlcDQoJZG8geyhqKSA9IERU X05PQkVHSU47fSB3aGlsZSAoMCkNCmBgYA0KDQoNCkhvd2V2ZXIsIGluIHBnX3N0YXRfZ2V0X3N1 YnNjcmlwdGlvbigpLCB0aGVzZSB2YWx1ZXMgYXJlIHJlZ2FyZGVkIGFzIG51bGwgaWYgdGhleSBh cmUgemVyby4NCg0KYGBgDQoJCWlmICh3b3JrZXIubGFzdF9zZW5kX3RpbWUgPT0gMCkNCgkJCW51 bGxzWzRdID0gdHJ1ZTsNCgkJZWxzZQ0KCQkJdmFsdWVzWzRdID0gVGltZXN0YW1wVHpHZXREYXR1 bSh3b3JrZXIubGFzdF9zZW5kX3RpbWUpOw0KCQlpZiAod29ya2VyLmxhc3RfcmVjdl90aW1lID09 IDApDQoJCQludWxsc1s1XSA9IHRydWU7DQoJCWVsc2UNCgkJCXZhbHVlc1s1XSA9IFRpbWVzdGFt cFR6R2V0RGF0dW0od29ya2VyLmxhc3RfcmVjdl90aW1lKTsNCmBgYA0KDQpJIHRoaW5rIGFib3Zl IGxpbmVzIGFyZSB3cm9uZywgdGhlc2UgdmFsdWVzIHNob3VsZCBiZSBjb21wYXJlZCB3aXRoIFBH X0lOVDY0X01JTi4NCg0KQmVzdCBSZWdhcmRzLA0KSGF5YXRvIEt1cm9kYQ0KRlVKSVRTVSBMSU1J VEVEDQoNCg==