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 1osFe9-0006aE-5d for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Nov 2022 03:51:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1osFe7-0006il-Nk for pgsql-hackers@arkaria.postgresql.org; Tue, 08 Nov 2022 03:51:31 +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 1osFe7-0006iQ-Cv for pgsql-hackers@lists.postgresql.org; Tue, 08 Nov 2022 03:51:31 +0000 Received: from esa15.fujitsucc.c3s2.iphmx.com ([68.232.156.107]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1osFe4-0003eF-La for pgsql-hackers@lists.postgresql.org; Tue, 08 Nov 2022 03:51:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1667879488; x=1699415488; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=uh3tPuR5eKQMN0tzoBVGjdjQQ+hTpNZLc03E7s2tcw4=; b=UFtE0g0hoC0wkuar7T9wHrTB4DKqW59Y0CvnCrDhohfP2e3HB8gOYk4l /40BfncGKVSiETlN08cHkCCKJF9YKuc0MoCU5ffeirLrthSyjzGDpNuk2 K0lPuFGzgV1DU1+OftmDpLt8Cg5/IdN7pC8aQM9fxLGKZD1Gwpwv3yZ6n EgJ7Pg47P9HcxOI0FQ0OdvzSpxH9ALmZkoMY8ec2wAE/iW9LjXgUYwyND c38EXA/SK56absYbxyMbCWWPhJjm8PxQI7AqEIO5cg/WEu4dFjXbiGxGK SKy3GaP/5OGHtqEWpBbcMhTAdoxl6ApG9+MHFwPnge67uQ6XcHm5xa9LV g==; X-IronPort-AV: E=McAfee;i="6500,9779,10524"; a="69410561" X-IronPort-AV: E=Sophos;i="5.96,145,1665414000"; d="scan'208";a="69410561" Received: from mail-tycjpn01lp2169.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.169]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 08 Nov 2022 12:51:26 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=aYtnktghh6OcVgHYfkXqqpFja3eNgTelMKL6k5EDcBkgg7w60fnDBv1MvZhkzJ38KKqWfy05tRLA8pYF0zEu/NICG7a+3ZJh7aexpZ4JBDyrM8jnhEQY0Pu+74sKXwL3HYywRGrB+4sqCXaOuYeo9ZHv6is+u3G6dEQkTiYkbTXcFDVnT0tlPcduI0ZnxM7hRF0ZMlhBq+Q3PBH65fFI6c2mJmVRktuwGjp3Kh0XqYVFer8Ku3K6GDZw/pJuzwrI6YVTiKIk6L632xk6sgoSAtsjSUd20EGhZbegIQFjge7VZ9MOcqa1BrIw+LziDhf4S9SKKbtMvPxHvLCsZhVrZA== 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=uh3tPuR5eKQMN0tzoBVGjdjQQ+hTpNZLc03E7s2tcw4=; b=kh5wsLRFNuom+ntOFoygVr/fnQ32LCeivXeHUFkAOWlNMsHTA4f6otexQU0HXefXjmPyGq11nEOGx67KXFb5eEw3Fp4E7kydK8lNdWd83ewkqA7U22HsjyxdymLFe1xbI7+lG/KILNdDQt+p3wmA7M4G1n+r8Jz1DUT8YQxpa9AJcoYEP9MGF5nY4q/g9B0DrKmTqA1Gm5VgAASVFkAFrLB62fGI2UH3Q7SOToC8WqFsg+n7cwxJp5sgXxd1Ucax/Mx+r+mHljPgcDT1OCT+E/wpBBgP1DK0HvVH+sctccc8MdBVL+mMTBPHeQSmJODs1QNnMlB2+nfk33Be7aimWA== 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 OSZPR01MB8204.jpnprd01.prod.outlook.com (2603:1096:604:1a5::5) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5791.27; Tue, 8 Nov 2022 03:51:23 +0000 Received: from TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::f4b:1dbf:dc2:dc91]) by TYAPR01MB5866.jpnprd01.prod.outlook.com ([fe80::f4b:1dbf:dc2:dc91%4]) with mapi id 15.20.5791.027; Tue, 8 Nov 2022 03:51:23 +0000 From: "Hayato Kuroda (Fujitsu)" To: 'Amit Kapila' , Masahiko Sawada , "houzj.fnst@fujitsu.com" CC: "wangw.fnst@fujitsu.com" , 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: AQHYSXX67NoYEfdPmEWsDniEZU+Lb6zlvxQAgAkRYICACBI2gIABs50AgAA5UwCAApvIgIAFAGuAgAXc1wCAADa7gIALO/aAgAsRZICAB606AIAS+CyAgAAufICAAWQLgIABHxKAgAA3o4CAAeE3gIAJPr0AgAkxzACAAiJoAIAC0hUAgARvDICABQA2gIAAFvcAgAeBmICABO9ggIAJO+YAgABu1YCACQzpAIAJSy6AgAS+zICABq7mgIABSJUAgAAOtoCAACmRgIAB78qAgAqL+oCADJWRgIAGVm0AgAGAQICAAerMgIABYRWAgAgvEYCAAWyzgIAGSRYAgAFBqICAAFYagIABchmAgAGqzwCAATq/gIAFJCcAgAAGs4CABE7agIAK5WIAgABrY4CABb89gIADiS0AgAEu2oCAAHBpgIADPWcAgATEBgCADdxGAIAAQoGAgAD/DACAABzggIAF+30AgAHyDYCAEzpGgIANkEmAgAI+mYCAAT6MAIAAZDSAgAEGEgCAAaJOAIABU6OAgAARggCAAAldgIAACGwAgAF0j6A= Date: Tue, 8 Nov 2022 03:51:23 +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?NTBfRW5hYmxlZD10cnVlOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJh?= =?utf-8?B?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjItMTEtMDhUMDM6NTE6?= =?utf-8?B?MjBaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD1iNTVlZTYyYi05ZmM1LTRhOGQt?= =?utf-8?B?ODQ2Yy01NzY3MjJmZmVjNzM7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?utf-8?B?MmFjLWFiNGQtM2IwZjRmZWNlMDUwX0NvbnRlbnRCaXRzPTA=?= 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_|OSZPR01MB8204:EE_ x-ms-office365-filtering-correlation-id: 72faeaab-1bc5-4d4b-9223-08dac13c80e7 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: wMcLp+tIMFmEVD0QhswmU6d8fOcfr6f4U00QfbqI1N1nSlsSu2LBcLpL8NJoQOIxeIxPOsvVcVq8uGyvc//qJdfoQpG+4T37f5YDKoL/SDQcKp7xf14ikrotLLr92T/hTqaa6L+73Gofm7jUp9L4+bKmdxDJt6Q0D9uax9Dffdjs3xm3qMWIKA2NUBmxAXQskb51AvPCf28cKcynPEiFbktDZDYx19kQf2JNtgTr3Itd8F2RikDbmZ5J63LVxQddX3A2pY+ipZamoa8YOUSfK8j5RaqhLQXuJ/2pjbKTNx/Sy/gJypiS5NHPn3iLBCoz6fQak//qTkcGlMRzimITmMJQSp1OrPC2usn5gFYaojhId/PLFEgZHFexHwg3oATc4mz2LrT8u3vMN7cpHYMu9ROYxbRvD7ueZdjqas9SCsgBFBnbtI0Q1mlutJWyz+CeN1Lqtkjq317wPQQ5aMEdGYhpxzjkepLRcXtICe1CzoNiKrM0MWmnRxyK8TRXMzd6C9VY+0mC/3nOuwbDiQS+FbW3nKbT9wYjs1qMDjBddgyyn1v+oYNDuMCJUq4dqpLBgjpkqS6U+CiAz9q5IlhOp5nsFLrJoDeGUwrKYZVLImhzrczgRWhH9gqTGXTcMJ2loVWf6tw3DQ8wuQAL7H9ht6GGSNPUTnWyoH7pTrAwTwl/kX/H2+xEAR0vzGBKujvGBiQZ4Vw80vYE8WS4SZC/oHpLm8iqPPBvCaFgGarkW7R3B5JQzT9cZv444suGk1XI+Pw81SKy7mF8ErrFbnLzVS7r+eHxwy6Fo6nWNPcw5V4= 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:(13230022)(4636009)(346002)(39860400002)(366004)(376002)(396003)(136003)(1590799012)(451199015)(1580799009)(6506007)(33656002)(85182001)(82960400001)(38070700005)(122000001)(41300700001)(4744005)(8936002)(2906002)(38100700002)(186003)(83380400001)(86362001)(478600001)(66476007)(64756008)(4326008)(66556008)(9686003)(66446008)(26005)(76116006)(8676002)(110136005)(66946007)(54906003)(6636002)(71200400001)(316002)(55016003)(5660300002)(52536014)(7696005);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?a1BESUwzYk9PS09xL1BKRlB3U2k0Y1l4aUppbFl3ZDRXb0p4eUNsUzdBYXVD?= =?utf-8?B?ZWFJRTU4ejZHNmY5Uy9rNFJRR3N3UFIxZTgxT0E3ZkRXbkVmU2NkNzJWdy9R?= =?utf-8?B?Nm9jU0wwaE5iOUdMcndDaEhqMlZIZVpLZjc0ZW5MaHFZVnlSY0RuR29PbDZW?= =?utf-8?B?Ym0wOURTY1JOcm9pOENKeE1ENTZVNjlzN0VJc2NLZTd2Zk1JTWY1MVlCR3dU?= =?utf-8?B?YUlSeUdKUWxXUnZyK1QzdlY5cE1FMnlaakZHR1V1VW9ja2cwUWhjM2U0QXZn?= =?utf-8?B?YjcwYm9BR2NCbDJya0M1T3N4UTZnVUFVd1Vueis4dy9DRUFtWlhxdWRwVzM1?= =?utf-8?B?OTJQNm5WaXMrM1dBL2w0MDBSTFFUTXZTckd2Z2RPSjdSRlAwQlVqbGRaNlhF?= =?utf-8?B?ODNpTnBoMk9nVE90TlAvblNDQXppcXk0VnQzdHhjUmRPcFZ1eS9YaVJHZlBY?= =?utf-8?B?ZmxZK2JZQW9wVDVEbU52dm1HWHFMWW1UVVI4L1F3NDZ6OVlQWnVaT0J5eDRq?= =?utf-8?B?NURoUER2MWVkcnhvWVVYTFVxTDdBWTN6MHJRVUdaS1J4dUVldHM1cmUrK1VZ?= =?utf-8?B?NVJ4ZUY3ZHNjU2JidWhGUWM5ckJpbUVUWUE0VW8wNlhWTWRNL2E0Nyt0ek5u?= =?utf-8?B?YWlsMGcrVHFiamRhc3VJQnBXRk52MER1ZXlkYWs1WDlUQ1hsWHNPZGdrSTc3?= =?utf-8?B?NnhsYkk4aEZYRGUySi9jS1ZRSnd4N3hzWnpZaHIxSklXZHNaUHUxdExXaE1O?= =?utf-8?B?UVpVRUNkRG1PRzdBT1NQVi94UVZWZm9FZEwrNkVNZkJSRUo5bFQ4eGxWSDk3?= =?utf-8?B?YmI2OWFOUUVrZFBPcTVFTGs1bEF0bVNtVlIzeUVjUEducjJNN2g5SStkNUZH?= =?utf-8?B?N3drUDBBK0JNNnVFVC9HM1NvY2dmZjdkbFgzL1hoa21VTVZ5djQ4NHd1TUZY?= =?utf-8?B?SnBjK0lXc0xyVlBNWW9vbVRrUnlIQkg1RVhNWldxQmpGSnk4dmswQnNIUFFQ?= =?utf-8?B?eElYMENwS0k0a0pwR3pPYkxkcHVod2VEM2NsL3RCY3FiWndEeFlYczhWSExw?= =?utf-8?B?SDNFY1VjQ0xaaHRadURWOWZ1UG40ZnRFU0h3WVdpYkluSnNtbTlXMENxZkx6?= =?utf-8?B?VjRlNHVXRy9Va1A3dUk4YkhWRCtNaEFhWlY2N2dEYVFjcENKZ3U5akNCRHRr?= =?utf-8?B?Uit6cEx6NE9NWTJKT1RjUHk0V1JFTkdZVUNYZVZna2d4ZEVHMFZSeFlxNTVH?= =?utf-8?B?bnZZNnhQL0IzN1JORFJRUjlQV2ZOTkR4Z292OWVSUVFNL2N3MHM3aHdQWnR2?= =?utf-8?B?ZVRHT0NVVVF0ZUJ6bzhOZGFDK2h4d3N0cWVPUENpNjBSb1dNNmlmQ3lza1pj?= =?utf-8?B?QlJiS3pUT0kzSXA3T0d5dXRHYVJqeXphT3E4alRrblJrV0hVSk9NeUk3UEhw?= =?utf-8?B?UVJQQ01LdlpQdUIvVXZTZUtwNldwVVFLZVRHN2ZJb1YvRmlPMnc4UUszUWR1?= =?utf-8?B?bFUySjd6UnlhK1BLL0FLOGI3MS9KMlMxQ25ibTVPSXIwclJ4czA2UE9RdTg2?= =?utf-8?B?VGc2OU5hM0tGelJpRVk4YTdLZ21aS3FEZlhtZzhRc0ZTZjBic2VPVzZOSkYv?= =?utf-8?B?aW1tckI3OWU5cHNYZ1MxZ2dCWndlQmpWUmNTZHI0Uy9pb05ZcXdEOUxKWXY4?= =?utf-8?B?ejdrV292YzFoN3ZWTDdCZGlaM3RDWExmYzBmTlRVUmtvQnZpeTVVNnM3c0FU?= =?utf-8?B?dmNSQjc5K04yV0FnRmFaaWJ2ZGh3SmRuclNXWmpZai9jcm54Q3ZPSWdBYmt0?= =?utf-8?B?QkFYQmhpWTJDSXhoeXpRSjJVdlE4WHJXT2k3dzFCc2lCdGVqRDdQZnFtWmdw?= =?utf-8?B?SnF2bEdiZUh3em5RUzl0bloxOC9iZFR5c1dld2ZjT0VURytRdE9Ea1N6c1pY?= =?utf-8?B?TEdNeEx2L3diQWJTQUtOTTB4anJvd3E5NnNKc2ZmK2NyVU85Zk1yZjFrQm1K?= =?utf-8?B?OWdFZWVlMEE5c2Vwb3o0YW9teStGa1NxRGdiVmQvY1d0dzFlNjhxa0hOaWlX?= =?utf-8?B?QkRhQzZva09sQzVGZ1lIbTFZUkVOMDJUN3Y5ZTc2OU5ucWc1Q2lLaVNKYnla?= =?utf-8?B?ZTAvdnBPbWc5RUR4bGwrcGtqcEg3ZlNrTEtZQnlmZTU0Rng0ZitmbnNGanBY?= =?utf-8?B?aUE9PQ==?= 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: 72faeaab-1bc5-4d4b-9223-08dac13c80e7 X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Nov 2022 03:51:23.1048 (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: U4hZuwZY1TUhWh9KkGE1bvG7L+vZSE1oWP2OX7AnwOD5pCsSJbXlt7iet0NLCC0LTjGWBk1sIamvW5z6NZn9+hCsdCGcdNQ5ToDxtRpsZqQ= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSZPR01MB8204 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBGYWlyIHBvaW50LiBJIHRoaW5rIGlmIHRoZSB1c2VyIHdhbnRzLCBzaGUgY2FuIGpvaW4gd2l0 aA0KPiBwZ19zdGF0X3N1YnNjcmlwdGlvbiBiYXNlZCBvbiBQSUQgYW5kIGZpbmQgdGhlIGNvcnJl c3BvbmRpbmcNCj4gc3Vic2NyaXB0aW9uLiBIb3dldmVyLCBpZiB3ZSB3YW50IHRvIGlkZW50aWZ5 IGV2ZXJ5dGhpbmcgdmlhIHBnX2xvY2tzDQo+IHRoZW4gSSB0aGluayB3ZSBzaG91bGQgYWxzbyBt ZW50aW9uIGNsYXNzaWQgb3IgZGF0YWJhc2UgaWQgYXMgZmllbGQxLg0KPiBTbywgaXQgd291bGQg bG9vayBsaWtlOiBmaWVsZDE6IChwZ19zdWJzY3JpcHRpb24ncyBvaWQgb3IgY3VycmVudCBkYg0K PiBpZCk7IGZpZWxkMjogT0lEIG9mIHN1YnNjcmlwdGlvbiBpbiBwZ19zdWJzY3JpcHRpb247IGZp ZWxkMzogbG9jYWwgb3INCj4gcmVtb3RlIHhpZDsgZmllbGQ0OiAwLzEgdG8gZGlmZmVyZW50aWF0 ZSBiZXR3ZWVuIHJlbW90ZSBhbmQgbG9jYWwgeGlkLg0KDQpTb3JyeSBJIG1pc3NlZCB0aGUgZGlz Y3Vzc2lvbiByZWxhdGVkIHdpdGggTE9DS1RBRy4NCisxIGZvciBhZGRpbmcgYSBuZXcgdGFnIGxp a2UgTE9DS1RBR19QQVJBTExFTF9BUFBMWSwgYW5kDQpJIHByZWZlciBmaWVsZDEgc2hvdWxkIGJl IGRiaWQgYmVjYXVzZSBpdCBpcyBtb3JlIHVzZWZ1bCBmb3IgcmVwb3J0aW5nIGEgbG9jayBpbiBE ZXNjcmliZUxvY2tUYWcoKS4NCg0KQmVzdCBSZWdhcmRzLA0KSGF5YXRvIEt1cm9kYQ0KRlVKSVRT VSBMSU1JVEVEDQoNCg==