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 1pMTjI-0002gL-Dv for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jan 2023 12:57:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pMTjH-0001Tc-9C for pgsql-hackers@arkaria.postgresql.org; Mon, 30 Jan 2023 12:57:47 +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 1pMTjG-0001TT-Ew for pgsql-hackers@lists.postgresql.org; Mon, 30 Jan 2023 12:57:46 +0000 Received: from esa9.fujitsucc.c3s2.iphmx.com ([68.232.159.90]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pMTjB-0001WJ-IT for pgsql-hackers@lists.postgresql.org; Mon, 30 Jan 2023 12:57:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1675083461; x=1706619461; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=ga6s662DyX08rFjPYCi959SojR7HqxAD0Ix04ItlIWU=; b=OwOdcJ5RDw7wcfvxCW18BnzJSU9udWl0gM2eYn0yHRD03YJ9DUDzeZeS f7ksOet2eTMlmPXNfujsmeEhGGEOD14wEM6pGwoGRwspU56a8ydyRd4nf fN4DYpQ6ZApN8b18oRluYiQpYTb5T4c+Sk7kwfW/7AzvpsIr9evZupiSm 7jYp46i06jOAecZbIkzKGqUNCcQ8evCWPy/0BvXzrn0g9uCE9qNVS49Nc 6XM3bxBWcWOJqWBW13se8xkOTwse/YOVansuHsRb1ksmdMjIRZHAhm7YS 0j1KPE/fZp6Zd1I4nk59YF5HEB7cL1vRAO9x0MhUbsmFMrNtaG6cqfuDY g==; X-IronPort-AV: E=McAfee;i="6500,9779,10605"; a="75844079" X-IronPort-AV: E=Sophos;i="5.97,258,1669042800"; d="scan'208";a="75844079" Received: from mail-tyzapc01lp2044.outbound.protection.outlook.com (HELO APC01-TYZ-obe.outbound.protection.outlook.com) ([104.47.110.44]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 30 Jan 2023 21:57:37 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=JDAwAhzp5JQgswDKaLFGAN820ERIGyv//FPZ/lvS1xe7d8DpSers6qRmJQSsy+IqGc7xC0JJ8Lb8S8Xxi7sBZH5IzCj9FHrry/CQvw5xNMigfdueoex3kQYylcufA6r70STUV/t549FUmltJm4uDIEGS0DiUeuma+U72Wba/TrXfEJnuy2ieIFeym/LhjtedeBd+/pTdGA5DmbyAHZHIKA/dUKw/NcGrqv2QpPY1E1/Sgm2st3Qww7CY7Nv/PLe1aK8UEi5uE4rfdjHi3W3IK9Jtx2RZQCqOuxy147lagqq6/rj3GkJYO/e5AUU64VAUxw3I626pAMQ59R/ZWz37WA== 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=ga6s662DyX08rFjPYCi959SojR7HqxAD0Ix04ItlIWU=; b=AUXCz6tCVCIFQCvMhLPtLYW59IEruvD2aHt+lwyDYEzE3q4xxuBw9is5r5Tc6lK14QNhw/WaZpcCaq8DrTYV2u/XPs+TUqp5MWbKaefic4tTFE/QcKCtDYghqxWhDDCuRk1YoyGp20MxA+qFNXcemOBR21TVUa1j5yKkdoexMrd+w1ITS6XIHSIe6VAcPvZxx5xEfgHhNyr88hlU98IT6VfCV0bed2Ld1n5tnijfzWCwYD5G67AAbyxW05zk0P4QiIHN5GXSjEbO1skELsmjLBGg2DUv0Vu52SlO9EvB//l+z6/U1s3nHyZOkkRPrXaybL+FChoOp/p4BeE/bnlKwg== 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 TYCPR01MB10713.jpnprd01.prod.outlook.com (2603:1096:400:295::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6043.36; Mon, 30 Jan 2023 12:57:34 +0000 Received: from TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::edfe:53df:fd78:7d61]) by TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::edfe:53df:fd78:7d61%3]) with mapi id 15.20.6043.036; Mon, 30 Jan 2023 12:57:34 +0000 From: "Hayato Kuroda (Fujitsu)" To: "houzj.fnst@fujitsu.com" CC: Amit Kapila , shveta malik , "wangw.fnst@fujitsu.com" , "shiy.fnst@fujitsu.com" , PostgreSQL Hackers , Peter Smith , Dilip Kumar , Masahiko Sawada 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: AQHZD4gpRLeoXPF6EU2oFdXVAnKNBa5uS4SAgAHPyoCAACQbgIAAHfaAgAGmKgCAAB5KAIADDzOAgAFWGwCAABIHgIAA+NgAgABKNQCAAf/xAIABKiIAgAA6H4CABGPrgIAAfUiAgAEdzwCAAHCvAIABHXEAgAIlRYCAAWA5AIAEvuWAgAE6wQCAAY/VgIAAWpEAgAAHj4CAAB4xgIAABTsAgADtCACAAE9igIAANW8AgAAFuACAARAxgIAAHcmAgAALiQCAAA7+AIAALE+AgAE5gQCAAA7MgIAANcuAgAEiKYCAAB1HAIAAIqEAgAHBWYCAAVCjgIADG7GAgAALYoCAAGDXgIAABJEAgAAYMYCAASnOAIAH4RgAgAGB8QCAAZyxgIAEhI0AgABQaQCAAYVWgIAAW9GAgAAAs4CAALL7gIAA+e0AgADdCYCABnhyAIAAbBsw Date: Mon, 30 Jan 2023 12:57:34 +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?NTBfQWN0aW9uSWQ9MDU3YTA0YTUtNWZhMy00NGNlLWFlNDYtODkyZTBlYTE0?= =?utf-8?B?M2M4O01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZWNlMDUwX1NldERhdGU9MjAyMy0wMS0yNVQxNDoxNTowOFo7TVNJUF9MYWJl?= =?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: TYAPR01MB5866:EE_|TYCPR01MB10713:EE_ x-ms-office365-filtering-correlation-id: 88454758-8cb2-4aae-c608-08db02c18e81 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: jSdnAjuqNwx6UCKx9wTPln3z8wjnzO411fLQTe2hsnqoQlifPv1KaiHITaZ4t/aoFEvSL1gPkHbsVXOMQQAcGFB7JVMFWjDOIjq16s6kpvtWRTDNwVvIRiMXXrHCtrMaTSGOAwoEoH3Pcln3Y1PTLV5E/i4qsZ3T7WyY4035rrofZbCpW6DvvUZLaPNWiguqXVdOXfiAExfx5o4jS0fKgtCcb9haYTHspC76yu0Y9yAXxeiU0J6Vnja5tCXiWUf+jbxCYU/ih0yoAy0GaB2957rZWpOn5JCRyXTlii+FD8B1wm46be3JpmLiK7EuD//wXo2rlo/vytFhTLxDgUvhqNlMsW3LFbGqdcEltWy10KQvGQPcYU5Mw1hCpT709xqrypIKI/qK6k+88H7emFn2rbGuAI9L+DH81Lp8P11ef2+4A7eeCk4QyqrkRHYER0w5nc96tHFQ4qO9xjlhfTdFLYx5HJHSIVDfMm6Ro5EIIpC6QT6p+z6I7BBBQrW4SiLHxt67k//zyMYSKOinpV6mgvmWoBm6jVkb2DCO3zSkTSELiZVrfupvGYkvSAbzoXetBERcRStQUG1fugWkvfslMmTikyGawbbJDNNJpKwWmFgzdWDfd2zTe70vjuxSo8h2/4+qhtsSD99deOEqb6HbJuN+NLEuDnSmS33vaiL8qVPVKuU+p7a6D7FWnk+vF5kIaCbxKmiHVx6XIslV/NpHDCNbYzXKepUW0TT2cjrlRok= 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:(13230025)(4636009)(136003)(366004)(376002)(396003)(346002)(39860400002)(1590799015)(451199018)(83380400001)(38070700005)(86362001)(122000001)(38100700002)(82960400001)(2906002)(7696005)(85182001)(71200400001)(6506007)(558084003)(9686003)(26005)(186003)(478600001)(33656002)(55016003)(8676002)(66476007)(66446008)(64756008)(66556008)(6862004)(52536014)(8936002)(4326008)(41300700001)(76116006)(66946007)(1580799012)(54906003)(5660300002)(6636002)(316002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?NG84RG5PVElTb2JzYy9qdllITTcwUFVUVG1OQjBSUGxiY3FxRStPWVpCZmh3?= =?utf-8?B?azkzOGdmRDhkRTFZL2xCRmtiQ0VsQzZOK2dyYkFUV0lINXpTUFhCdmNWVEQw?= =?utf-8?B?SzZLZUs4SFFpcERDV3pJbjR3SWp3YWZDOGhsZ3FvNXFEUWxOQmtSTzRINmll?= =?utf-8?B?RkpidUozUlJ3OFBGM3RBaFFJRm9Xb0FkNFF3b0pWZVVpRnd1Ny9Bc2tCMjZ1?= =?utf-8?B?eGFVY2l5TDNUTkJ4Z2J0dWU3eXZGbSsyUnhuNVdPc3RjVXBvbVdaYnNJYTBV?= =?utf-8?B?K05BOUZ2Slh5bVdwNGkzSXhYN1pXNDhHcTBLOXl1cklnSmdCTmZMVmJydlZl?= =?utf-8?B?bXBFN0NnSFA1eDRvM29zRTcyQ21IbDNYN0M5cjhZV0l2TC9CZStYT1kxdndu?= =?utf-8?B?TGNoSmo5eXlSWUROd3F0bWsyaTdSam1hWElFTnQzbUNPWFJmQkx6dkhtZnpJ?= =?utf-8?B?S0VwdFBVdkJscTEwT3d1azhSOHBMUy8yTHFMZlZTUnBTKzFUZUhoVnJTV3hl?= =?utf-8?B?VytFL3VkaVgwQ1QvOE9CNkw0NTJhSkVlbTVxU1J6S01CcldZM0d6VXNHMFlY?= =?utf-8?B?cFlCWjEvbUtWZWN1a1VuK2kzMFhSQmZMVGZtNDc4MDFtdWtBbnVwZjZvU0Q1?= =?utf-8?B?cFYzSGRjVU84ZFpEZ2djOEFjUUloV292L3N0OGpRUHJXSFdEK0w5RkMvUDc4?= =?utf-8?B?bFdsVWtmMzBicENlY3pza3RTRG5jZXNYUktWMHkxbERoZGVDckRwZnYySWF4?= =?utf-8?B?RWR3UXNES09wNDg3RGI5VWVDeVhZaVA0QkxyVm9Fak51V3pFcTJsNnVDdFNk?= =?utf-8?B?V21JQUxEQmlCaTAyelJjb0FQZTU2dXgzUWFwZnI1RWY2NmxpbzdLMSsrNmI0?= =?utf-8?B?cmh6SWtjbEtidS9Obm93b2VCcUU0V0MyNG9IZzBhRGNWa1VVYVFOQTE5RUQ0?= =?utf-8?B?ZmtrcDhnSzRSaDJsSXRVYnRaN0w0eGlMbFltYlBneGN2aHJKcVBkVkphUHlK?= =?utf-8?B?MkZoRXhvM3NLVVJjNWhrVjJEYzFiTVlnSjMrZk8vWmZ4d3Q5dDlocDFSTjcw?= =?utf-8?B?TzJvWnAwREh6Zmh6R254MUd5S3dkK1hydTdwRFV5SC92ZnBJdzd0TmFtRDFS?= =?utf-8?B?b0NZb0RKWXF4VFFlOStGaDAvc1dKMTgzZkY3ekNYY01Gd1JqZW82czVGZG4y?= =?utf-8?B?MUhqdFBuMENIUkJSYmNyOTFscGlIYVQwY1hxWlVaZkFWUkVTMXBsZFRuMlpq?= =?utf-8?B?N0FpUDA3blBDNzl5dTlYU1pubDVmVktEMjNwZkpkeThSeWFJclZuWkREckxt?= =?utf-8?B?cDlrYzVBN1dJb042TW9WeUpSMWtINlBwNWRjMEZqcXQvN3VzbUlrTi8yM05x?= =?utf-8?B?VzJGOWRTVXBWcWFIQzFZWHdQOWRIMnRNbUpuT3hzcitRVkNQNTlDd0tVZHpH?= =?utf-8?B?amRKdWtJbUxwWDI5bStBbnhHbUU3RkVOWVU2RTNxdFcwZmRIbzM4Zi83dUxi?= =?utf-8?B?dnhrcWhwT01DeFJMdGg2ZkpocHJyZjBKUG1tR1h2c0tJNlVRS3IwZlFvenB4?= =?utf-8?B?QVpOYXdGdVZ6Y3BUOXNoRUJRc3NrOWZHdncvSjBzVHRhc1VIZkVvaWlHMHh0?= =?utf-8?B?Q1lpb1lSTTU2dzVOSzFlSThNdVFFbldzTWdhSUpBR2F0Q0pUSWhDM2tGdWta?= =?utf-8?B?NnpsRms3ZW82cko3NDRTamx4T1NhblBEYkppUVZ3TWV6OVZXektQMXM1aVhR?= =?utf-8?B?QnNMaGIvVWtqbFAyMHVQdWtzZWdNNmo0a1pvS2pTYnV2dVBTZkd5RE11RXdj?= =?utf-8?B?Y0ZVamsvSEltK2MyWFl5Y2FJcEFXODN2N0JqMXNyZ1ZOR2orcCtVd0dZVzBH?= =?utf-8?B?YXRxV1B4UWNpUHZMTStVdXd3eFY0bC95dlNRYlJYRVpaZlI2bzN1WnNSREVN?= =?utf-8?B?dTRkL1B2ckhtSmxwVWQxNmtOQmc4enNpM0t2NE1aSWZaWGtkTkhGSzBPRFJC?= =?utf-8?B?TTNrL05FWFF3bnNiaTZ4aHN5K01rcSt2Unl0OElZdXZnNVlHcGowRHlHYmdn?= =?utf-8?B?eENQTVZJSlAyZkpMMHRaYlNzNnFHWThyVnZ0U3JteUhKSEFWWkcrMThTNkxY?= =?utf-8?B?SUt5N2tSNWFYcys0Vkovc0wzcklzMnB5NTNzdXNmemkwbmZUQzhONEQzU2I1?= =?utf-8?B?THc9PQ==?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: fwdUjFSvVCxxc25NQd2uqbx+nuVoYiXZ9WafPFqma+uJwszdED5GOS8tep+/6ThDYCJ+vKybqapMGoO8q+lVyJzDhtkHi0MrxqO82pdushS+ipA7Qg0IiGMSZyAaazGM1FAqsZfwk556E+ydrZgNrM6VSJxVT4+oTVNJ5PMD4EAiNRBBNLWGpG+gEV51IpkYKDsnSfYJGNPVC9mOSfCrdEHa86tVtSpg2DGfSVR+I/AZ5SQbEODLcN00Bvbvb9E/7aEYjcbPDyj0oeJWIliUsFgVDiVhj3083BWsNS9x1s5yCEnSu8UHcW4W7WuvAleEb+MsMvkwWgcsTHxvsX6QuIlQh7LpQGKuborVOjarP9CizOqrj3U3eyAc/5TwD+d8zrnzDoeD58/beNd8PpCrW8JSGOtQas5k6dfj91m2Oe/lz9I/2DZEPnPAoFLYNzHVfCYbUdynKaalDcSQu79y7s94BqTgzEd3nm6hU6d3lnZNWRW3HgXA47zS3focwSv6fyI4yaGT6rfmQUFe/+8hCrl4tROJtJXbORtHHf700s3fQ28sQqJUGsxMNA2+m4ZWuvBKD23kzyiY89WqNr21C99mMcQFCwiBMdrfqRUZQrohmmopd6SO253IXCrL3O7JIZ258tlamTcvU09SJn6GbNyxGtN6Sysc8/jB2RIB9lxRlr+MBmIoCWAhegbEjmVhvl1+bXoWN53xWDlvPOaPAaRBu3EiUPaeCPu4S5AneelVBXj/i4YMy+J4LorPAON4W3NtDb1AbNK10qAL4s/Ste3DkW7o30UOzD+0UzsBtKCpajAbVPIxNm+yx475D7fK 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: 88454758-8cb2-4aae-c608-08db02c18e81 X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Jan 2023 12:57:34.5714 (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: pHkxzwRuDp+X6Y3qkq8H6DQZ6LmExzKcBR6/OTlOfCr6UHSveh+aS6fBb8e6Awu5WUD0j2wnYOG1hLBd1vF9LSRFP/9vB/HqQWcFX8R5sVs= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCPR01MB10713 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBIb3UsDQoNClRoYW5rIHlvdSBmb3IgdXBkYXRpbmcgdGhlIHBhdGNoIQ0KSSBjaGVja2Vk IHlvdXIgcmVwbGllcyBhbmQgbmV3IHBhdGNoLCBhbmQgaXQgc2VlbXMgZ29vZC4NCkN1cnJlbnRs eSBJIGhhdmUgbm8gY29tbWVudHMNCg0KQmVzdCBSZWdhcmRzLA0KSGF5YXRvIEt1cm9kYQ0KRlVK SVRTVSBMSU1JVEVEDQoNCg0K