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 1oGvwS-0000zp-3G for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Jul 2022 05:20:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oGvwQ-0000gE-7q for pgsql-hackers@arkaria.postgresql.org; Thu, 28 Jul 2022 05:20: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 1oGvwP-0000g0-KO for pgsql-hackers@lists.postgresql.org; Thu, 28 Jul 2022 05:20:09 +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 1oGvwM-0008Jg-TB for pgsql-hackers@lists.postgresql.org; Thu, 28 Jul 2022 05:20:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1658985607; x=1690521607; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=raU6482ejZgIPlt9tx9V07yZ23OVuJO2PO5fCLts25s=; b=XO5DvyoTmF3ttTSVZJNaeQptddNU0VXKyHUWy6Yc7sbqgDjEfG1CG/6W +LDsd2/+vmNjiUrpO3D+25AATayMB4OyInPTzdZUMrqXXF0kFeVVKOC69 Pvyraxoey0ro9jUNmWoaSdi+M7x4uu6ipeMEdIg5z2D0dCBhM2VKAosuq /F8S6zEfJdJG3yqTmR4po9FoyX+SP+yFVYvEyzlNYWeaGRYHqRxoUcI5A QtnVpxf+dPetleZ5Ad2N5bO8O0k9tJgEwO3/pdORODgjTFkuPsVcbR6MG H91DfR6bv2A4Dyh2jr1gAFXQYvPzi3NF2kUifC9JdThnpjAwH12YJOPzl A==; X-IronPort-AV: E=McAfee;i="6400,9594,10421"; a="61409323" X-IronPort-AV: E=Sophos;i="5.93,196,1654527600"; d="scan'208";a="61409323" Received: from mail-os0jpn01lp2111.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.111]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 28 Jul 2022 14:20:03 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=h/dvH4RwHPC/JSdjeh9NzFi3OH5O/e/ou1uyOC5uin7X3MPSJUXR+z3OQ/XpaUXKoEuc/zeGBjZB1Tg7XoIee9VtzlWLlHV86MgrhWLw+s6aFd/ssuGtYJcH6W7dvE6BZnmXWliApp17tQKR6uN5hxBmkzMtQZL3xr5Lx/1cgchImQL8WlUpDw91pX0TebVPCxrWpzenWbm4u5oNs4eLlGjxVr1JTBoi7BCFL9mK4Z7mfjCkEn+hqSW2Xqc+iq7TD5fi144merf86cavxLE6VE2A4eyUPch7WzAWAmAG1twGLuWAXK4KGONPr2NVSMfRwDlryOS7qcq1QNS+tGr5Dw== 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=raU6482ejZgIPlt9tx9V07yZ23OVuJO2PO5fCLts25s=; b=nLvixecnCxTL5pu1CBBTqlI9/J/Q8yaGfZfwiXe6tzpfwbx8fUah4MXX9gUkqV85/DlGDid8zN0/IBmGNb7wIzaMay8eiS+Och2qXNnOsQ2r9WfZWfvh9yOR+T/m0Iij9V6/MZSdKwwvndnOKlLUwO6fKH/bSjQUaTcAOGW0lt7b7dvoE9eSTgSz9ByO9pMplGIMYiiH/+A9ndSjGAo2KyVIil9WgZt4And+MhqJZ8EOW7wv0r3HCDdbTifkz47fdR0SOd6/1OrHgMshIFrxTY5ODjbGl7e1eh00n2wdXVe1Ttzmc+RDpSiUQvnxAP14X9qgBdmprzTn8f4gtmGBpQ== 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 TY1PR01MB1723.jpnprd01.prod.outlook.com (2603:1096:403:6::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5458.21; Thu, 28 Jul 2022 05:20:00 +0000 Received: from TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::a0cd:dc5c:2d27:85fc]) by TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::a0cd:dc5c:2d27:85fc%7]) with mapi id 15.20.5482.011; Thu, 28 Jul 2022 05:20:00 +0000 From: "kuroda.hayato@fujitsu.com" To: "wangw.fnst@fujitsu.com" CC: Amit Kapila , Masahiko Sawada , "shiy.fnst@fujitsu.com" , "houzj.fnst@fujitsu.com" , PostgreSQL Hackers , Peter Smith 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+zICACGi20IABKR0Q Date: Thu, 28 Jul 2022 05:20:00 +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?NTBfQWN0aW9uSWQ9ODY2ZTJkY2EtZTFmYy00OGIzLWEwNDMtYTBhMGM3MDZm?= =?utf-8?B?MDIwO01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?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?ZWNlMDUwX1NldERhdGU9MjAyMi0wNy0xOVQwMjoyNToxM1o7TVNJUF9MYWJl?= =?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: 609445e9-de86-493e-a9af-08da7058d1bc x-ms-traffictypediagnostic: TY1PR01MB1723:EE_ x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: TFt6w+d+waTamD/pMjXgXd1pyth8o5ki9RJwnlC5BgwIq8vPD6UFebJLxuqOndAFjDAX1Rtx6/g8bb38tbSSYC+iSFW4ZycoCczW8CANVM+9394SF0rUERqy4rQ+LPLn1cXFXRAuBxqJjGr8x6I6GJKRD+QYdAz54ItEjiHTMXcJ9Vk6sEouqRVt23yN/nkxaU+9azqWG5aoE/mz70T11TC688lnKxCujkJVz9mQSdCQU2exxMWr24k1AyjfTjnC2muWlbMRwVy4jiwiSnmtOLylIxqWn2njzbzTVEdS6l9wuXhxHrrIpB+ziXa0fN6L/Ob2A8EkYFxrFjh0ml4u2XnDaEuizfPa918/8GBRMuZ/zDDHNfk0IXe95hbfQlyaWHCvQZ0m7LZz/XZYzK0PR5gT6B/llepPKs4U4L42SuQ3LGYM0RGSS7bX7uFV8Intk0lOz5RBEFoLHTpDgBME5m2aELFOlUbxUpimHXKUbh6U6Hl8J1PPs6KM6vkIM+i01UbniRHD23QSoJQG4kpW/vRAvpp3LNu68OGvZBclolwTjAENlDSFuPml1i3A/1yqVh3rt5KK4nJprpWSHOpBrq+9zxQk3yH1kce5ffJpB9gXdII6qEUGTz8umQSJhcU+yFPVBNtBkNYxLp1CxEsXE8PR8bIF+QSU/xuiONscjJiDvE0vK0cg0td4lCMR6ryftElz/q3BVdMOYwgtfweYcxwDv+pKhl07ZeBiIEhCEo/HvPde+uOCiguoS0X4E2Rxb1IKamf0GcOPMw40Z2t14TBg9fAXd01/xk56K2kZe6u9bCU6Tz1BynJQ+I9fjzTf 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)(346002)(376002)(396003)(366004)(136003)(6862004)(66476007)(5660300002)(52536014)(76116006)(4326008)(2906002)(66946007)(8676002)(4744005)(66556008)(41300700001)(8936002)(122000001)(33656002)(66446008)(38100700002)(85182001)(55016003)(83380400001)(64756008)(38070700005)(26005)(7696005)(478600001)(71200400001)(316002)(186003)(86362001)(54906003)(6636002)(9686003)(6506007)(82960400001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?TW1jcFlERnVQOUplVTRHSHpTR3J6NS9uS3prcHNiQlRvODNHWlErc0dPTVlv?= =?utf-8?B?RmNsaTlyVUZjQ1Frd0xvMjBocWc1NVJNbVFUYmVhaE1LNlJaaHhvNHZyM0N2?= =?utf-8?B?UC9SSUxDOEJCdXA0ZEFFMnlyenI3RHdzOXA1YktHMGRWN05JMTlGZXVJd3Jq?= =?utf-8?B?dDBFWktJVHBhVGxoblQzYXd4RWpJeUswdDIyc09kVzYzYTF6RXN5STBqNXc0?= =?utf-8?B?dEM3ZnJrb3A3YjVxd0FKcTFiU3pOb1Yxc2lRa3o2Ymg3dVVFZGFCbnE5eWp4?= =?utf-8?B?Rm10VWc5dlhtTVlYZ2lnK1ROUXlPVitTNjZlTCtaL21KMGMrcUJqMlZudXc4?= =?utf-8?B?dDhtcE5pbGE1ak5XcGI1aW9PZFMwQzQ1bW5hQURJOGZtUlZiOUYzcWJYcHN5?= =?utf-8?B?c1VvUWtOYzgvTzU3TG5nZmtDSENFMzd0RkEvN21JTzNOSUlsK3NGQjRlUXdj?= =?utf-8?B?OTZLOFU1N3hlT2dGeHZuTHp6c25CNXF6YjMzczk5VVpyeVpvSzU5RmlQUU50?= =?utf-8?B?a0lEMHE2cU0rUmlqeDVoWCtEK0dzR1N0Mm9KSVpQTUhaNnY4WGxUWkpia0R2?= =?utf-8?B?dTZIanloMmlDYVJyT0FZTlFQRjA3RmlpQzdUOCtldTZabFh2b3BhTEIveFQ0?= =?utf-8?B?aDlLWC9lK3pUSjhUVGcxRXM5SG1tc2ErekI2QytmWWZHeGRiSlVBajVFN1Zt?= =?utf-8?B?OHAvRldwSWYwQ3h0WWpFbW91OXE2RFhkV0k5TlZBUmhtNW5nck1naVBTYkpj?= =?utf-8?B?WmxZaGdxL2lRdXByS3M5VEZzWXVPWjVGRENoRkRuMnRPTk5TQnczYzBqTWVx?= =?utf-8?B?NTVrRE56TThqb3UwdkFqdi9ET3RuMUV6UkQ0WFhDR2M0eWl1anRqYk1QbXRI?= =?utf-8?B?WGNCS0hndUpYWkhjeG1OS0MzV3BwWHpseWRydEdJRUVzMkZUUmRuSEJkS0FE?= =?utf-8?B?RDBiTlV5VTA0dTBTeFlrdkpEOUdpSFpTYWkxTFBpdW9VaDd1RXgwTWNwNjhj?= =?utf-8?B?QlpIVXlGaXhlbjkxR2FVbEora0htaVNKTmFhaHJyWnFqL0E1VXFBOHEra0xR?= =?utf-8?B?MDVCbUtuVy9nbVBIQ2wzTmZQNkwvNFdQWGErNTBrem9CL2J2NDBxdXdmd2ov?= =?utf-8?B?VThyRVg0Mlo3Z1VXZEF1cDRFdTU3azNnZkMzMG0vNFc1QkZPV3dHdTdIaFVv?= =?utf-8?B?cWZGRmhWRUZmdTduZXRJM29DUlBrSXp5ZHhVclplRWNxQ3ZxMENnVG8rK09K?= =?utf-8?B?a3R5M2grdFdMQXlHdEREV0NtNjRrT0F1T2pIOFY0YVNQQVA5eVc2R2JOSS9a?= =?utf-8?B?U0paT2twc0ljcjBCTmRjZysrTm9lcmJCL3NINnpySnp2V3VlaDBBUklhSVQy?= =?utf-8?B?cUlxTklDemRVdmxQSlUzcVFVYTRkelptUkpobzROelNhZHJFUWhUZ0dvVFVU?= =?utf-8?B?VXBlZkFUdjlCK0JZMWFPbzNiOFROVU9xa3VRbm5FamxzcDNBVVdnRnB1Ny9n?= =?utf-8?B?SGduOStGNnBmbGFvMGgxdzlrU21oQ0hWN1VwemJpNDhsY0tmNzZMZUg5S3NU?= =?utf-8?B?YVc2ek9SQUFMaXVwZ1JtS282eTg2a25EcmdOQURJbmFkeGRBc25MWFc1bkdG?= =?utf-8?B?UFdCN3VmYkJKd2ZEcHNEelJOT2JhRzAzR0paT0ovUEFvblg0Mksvb1NKM29a?= =?utf-8?B?clE4V0Njb3VXczlsaFhjbHI4a0kxaW1CUzJBeGJiMUlGWC9OWHl3VDYybys2?= =?utf-8?B?Q29NU3lCR2NpNnFMajMvSWVTYytwS25yR1BoS3lRLzNYZ1d5cldhK0pxYUk5?= =?utf-8?B?Z28xUVdZVlQ0RUN1RVUzNWU0YkxLT0U2Ui9rMGl5di8rbHo1LzJGdmM3V3pV?= =?utf-8?B?OFY2QXc1ZTdndDZJOUFnejN1eGRUWHBuMVFhc0dvVTJKRlRGL0hhR3loc2hh?= =?utf-8?B?VVErK0x1Q2RVd0ZsaUpSYWpwL0F0bG02UkVKSEZrck9Sc3hKR1pSZ25iOWd0?= =?utf-8?B?a3gxSldPMHdlaEN0ZHFZa282R0xVVTRCUGo5SEdpWm5NUTZtSVQ3c2dQZ0tI?= =?utf-8?B?NW8vNjcybFYrL3Y0TGIyZi9wWkNrakhtUWxPckdjd3N5K2lncGtuT1A0Y3NE?= =?utf-8?B?SjI1QWcwdlk3VVZKWVI0NzJZUy9EY01FL2xGWm5kUEY2dTlObjdnNytuWVNW?= =?utf-8?B?NGc9PQ==?= 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: 609445e9-de86-493e-a9af-08da7058d1bc X-MS-Exchange-CrossTenant-originalarrivaltime: 28 Jul 2022 05:20:00.4113 (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: PHyx5NN8spE7reD7ieZpu0utgu9WPeH/ghCVIYBnTZ7zHTSFMHMzAzNYqmq2L3UXmTQcS2H39YqosqzIgdVlVCkePy3VbX+kdL/F2JGkC9U= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TY1PR01MB1723 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciBXYW5nLA0KDQpJIGZvdW5kIGZ1cnRoZXIgY29tbWVudHMgYWJvdXQgdGhlIHRlc3QgY29k ZS4NCg0KMTEuIHNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3N1YnNjcmlwdGlvbi5zcWwNCg0KYGBgDQot LSBmYWlsIC0gc3RyZWFtaW5nIG11c3QgYmUgYm9vbGVhbg0KQ1JFQVRFIFNVQlNDUklQVElPTiBy ZWdyZXNzX3Rlc3RzdWIgQ09OTkVDVElPTiAnZGJuYW1lPXJlZ3Jlc3NfZG9lc25vdGV4aXN0JyBQ VUJMSUNBVElPTiB0ZXN0cHViIFdJVEggKGNvbm5lY3QgPSBmYWxzZSwgc3RyZWFtaW5nID0gZm9v KTsNCmBgYA0KDQpUaGUgY29tbWVudCBpcyBubyBsb25nZXIgY29ycmVjdDogc2hvdWxkIGJlICJz dHJlYW1pbmcgbXVzdCBiZSBib29sZWFuIG9yICdwYXJhbGxlbCciDQoNCjEyLiBzcmMvdGVzdC9y ZWdyZXNzL3NxbC9zdWJzY3JpcHRpb24uc3FsDQoNCmBgYA0KLS0gbm93IGl0IHdvcmtzDQpDUkVB VEUgU1VCU0NSSVBUSU9OIHJlZ3Jlc3NfdGVzdHN1YiBDT05ORUNUSU9OICdkYm5hbWU9cmVncmVz c19kb2Vzbm90ZXhpc3QnIFBVQkxJQ0FUSU9OIHRlc3RwdWIgV0lUSCAoY29ubmVjdCA9IGZhbHNl LCBzdHJlYW1pbmcgPSB0cnVlKTsNCmBgYA0KDQpJIHRoaW5rIHdlIHNob3VsZCB0ZXN0IHRoZSBj YXNlIG9mIHN0cmVhbWluZyA9ICdwYXJhbGxlbCcuDQoNCjEzLiAwMTVfc3RyZWFtLnBsDQoNCkkg Y291bGQgbm90IGZpbmQgdGVzdCBhYm91dCBUUlVOQ0FURS4gSUlVQyBhcHBseSBiZ3dvcmtlciB3 b3JrcyB3ZWxsDQpldmVuIGlmIGl0IGdldHMgTE9HSUNBTF9SRVBfTVNHX1RSVU5DQVRFIG1lc3Nh Z2UgZnJvbSBtYWluIHdvcmtlci4NCkNhbiB5b3UgYWRkIHRoZSBjYXNlPyANCg0KQmVzdCBSZWdh cmRzLA0KSGF5YXRvIEt1cm9kYQ0KRlVKSVRTVSBMSU1JVEVEDQoNCg==