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 1oLlnc-0006bb-9D for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Aug 2022 13:31:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oLlnb-0002wT-6z for pgsql-hackers@arkaria.postgresql.org; Wed, 10 Aug 2022 13:31:03 +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 1oLlna-0002wK-Pd for pgsql-hackers@lists.postgresql.org; Wed, 10 Aug 2022 13:31:02 +0000 Received: from esa17.fujitsucc.c3s2.iphmx.com ([216.71.158.34]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oLlnW-0001Yl-Pm for pgsql-hackers@lists.postgresql.org; Wed, 10 Aug 2022 13:31:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1660138260; x=1691674260; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=2USVSgbFoKeFpiVZfyw8j0MDoJTTQGHrUWe68kSNQwo=; b=QNlaWwzqajXUimhdpxQdAIQ3N0sDaqVbjtaR8NUrdgRBVhRbtPN3G6wT iP+rQ9mUNRXIRHl+UMmq88pObmFJThE6p0YQ5HqAaVmaUaKezRo3ITIih 5p8yivhvns5+hg8KqgzBQGH/6R5iHnQZ5TPtrsjDUtgwjz/Gav3twr82q vSlOhWeml9J62nUPt1CFIbCRbltwisUepbwNzgtQ6XVMazdzV5F5ZPMPG 7SEqlKvhoK3+Vc+VAM4KdZb8ha8FP2iHfsZ1oL4HU2YPUrsktmdunmwCy hlEt3nvIb/pRlGUqkciGL5fVEaUwWD47coW0PhGbYeU32rfgmrFHtfhXu Q==; X-IronPort-AV: E=McAfee;i="6400,9594,10435"; a="62452896" X-IronPort-AV: E=Sophos;i="5.93,227,1654527600"; d="scan'208";a="62452896" Received: from mail-tycjpn01lp2168.outbound.protection.outlook.com (HELO JPN01-TYC-obe.outbound.protection.outlook.com) ([104.47.23.168]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 10 Aug 2022 22:30:57 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=GEFnF8K4iBTduB0RxRiG3oJ/SZmMlHsD1d8LjaaT9CYR985xMvVk2GvOeK5jdnix9sjxVW6s8wWbBa8R9xM8mz8g0WBggIanPdt2I9lYVOnfBxzEyOh9gvrqTq6YG4h5i5Ok9nbijv/qe2PNjxMQrsBKpZ3Up+NNzXjP7FD9orrsYXPYMAi91YmXN4tFFhSMq3gTc3VYAXQHjBfYj+sl4tcGAwpRBjzt9hr0FmTJNb5l4f5Sp1pXaHqJaDgl0bP+KP4nl1irWiPbOP6EDjeLOnSv3vqQo1t7dmYJu7+TKASpltWLh2m701bJlmUgnWWau8D7gljxbsle/aCxhzLUbA== 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=2USVSgbFoKeFpiVZfyw8j0MDoJTTQGHrUWe68kSNQwo=; b=QnRuHbTiN6kVQJrE8OutKia9PsKGLD6p3rIDpWQaQ71vhd0DiWLo+gLyyJbW35Ivu846vHC9iKCow4NzPLFtZKAtyGjrF/Mp3V/DzYahvF5+A1loY2EgcQPzWDvLiImmQC5c7LCQad2PEFLTj1fnzjb+C4PpnhZOvqxSKOvV2xZ3IB9o0fXf4Qgbv3WKWOvOalqjxIPj+ftqm3k8odGoM7rDyiUYnl1mgtDDxlGLgwsd4gOKkrGA+MSZXXO6VVMXGQIfR4yRYV8yFlCq+mZzWJGh3QMDBFb02VaTmKFc1KQzzmEo4TliYJmlppnTWbsUZFEEYT1QdsVO8Qk2ibYkeA== 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 TYWPR01MB8362.jpnprd01.prod.outlook.com (2603:1096:400:161::6) by TYCPR01MB6622.jpnprd01.prod.outlook.com (2603:1096:400:ae::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5504.14; Wed, 10 Aug 2022 13:30:52 +0000 Received: from TYWPR01MB8362.jpnprd01.prod.outlook.com ([fe80::c89a:4fdf:3cc8:f0cc]) by TYWPR01MB8362.jpnprd01.prod.outlook.com ([fe80::c89a:4fdf:3cc8:f0cc%8]) with mapi id 15.20.5504.020; Wed, 10 Aug 2022 13:30:52 +0000 From: "osumi.takamichi@fujitsu.com" To: =?utf-8?B?J8OWbmRlciBLYWxhY8SxJw==?= , Amit Kapila CC: PostgreSQL Hackers Subject: RE: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher Thread-Topic: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher Thread-Index: AQHYlfR/7xgbR5UsAkK9uNqXDczsoq2Ds22AgAGwYwCAAVjSgIAAp0wAgAFDuYCAAfjlAIAVnJQAgAUWeQCAAvqsYA== Date: Wed, 10 Aug 2022 13:30:52 +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?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjItMDgtMTBUMTM6MzA6?= =?utf-8?B?NTFaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD00MDM5YWUwMy0wYzk5LTQwODEt?= =?utf-8?B?YjA2ZC04ODA1NjBlYWM4MTU7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?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-office365-filtering-correlation-id: 28f41afe-a120-4e01-18b5-08da7ad48c1c x-ms-traffictypediagnostic: TYCPR01MB6622:EE_ x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: pgJogzOyZy66HQskg4VtIgGVQbavrDQ/Dgqukr6jGHy+y+7xrxxOikCsq4cvEXbAIk1yd6fCj1ukCRp+8N9QAVPKLEjO7i2/WvzYCJI/eUTf1xRPpYF4OipNVbd6fS4MxV97m8rAW5adD4OgCNUR0IE0LP+IUtuL8Tp8tTHqw3ahhh8wj4ks7F52Q1Foj8y0NJxVh8TFro6ZmONedPgl7m6JlPMYQ6IHLV0CcRlLP1xtX0SzJizPajqV83H0vlF8zKpJ0/ZSQd/kmfStGJ1gUT2Nw66iLqsyqNMQIpqbYWzYYkLA/iSpUh+/4oePOjQTKCqMh2LQmLRhdvdEjtR8s3c+DxhedclJcPFakEeBaDgnBvq1VoGi1qvdd1/jfTrpEBCYtRweCQ5aE7/TO/LPdoz3i1l+nOVkVpApgCrJa6dvw1J2B+O+Y6h2A8ejniytDchVfW3iTbeBLE9OL1Mxm5Lx2gtEYGLdTYlvstDSji9f/sPTdevYzz/xpu7QBIfleaYpzq6CydNFifp0/umkJoJLI+8sKRbBo2MHwwxgLpVv3nZ5oVmS+g3Bt9/GyrQWGxjymxaESGOsbCW6cWNDNNf9NS9vU2X0vRvc2GZ0L8exdazw/OvWUmDKYlhgl0Z4j+tYEuMc67OyWKQytKBlzuEAOPpkpfTLY0OkfI/YYHK0G9Uf7a5BHc7xCPQxq6LLV7nfmc3qwYbn5kQIEf8EBI325rBqTGxzMgBmxEELJiP+lXDms+3FiA/yK9XIspio6ovI8DwC6jgsRd6Qr01lXDBwN4BbUJlhbKU16oU9A0PsjhleeaMdfVsOOheadgxr+ic+XEN1KfbvQMoTDk7DCg== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:TYWPR01MB8362.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230016)(4636009)(39860400002)(376002)(136003)(346002)(396003)(366004)(71200400001)(478600001)(41300700001)(55016003)(2906002)(33656002)(85182001)(86362001)(316002)(110136005)(8936002)(66946007)(66574015)(186003)(966005)(9686003)(38100700002)(83380400001)(53546011)(82960400001)(6506007)(7696005)(26005)(38070700005)(4744005)(66446008)(64756008)(66476007)(66556008)(5660300002)(8676002)(76116006)(4326008)(52536014)(122000001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?bmtNSGQ1WWhKNjZUTXd0RkFjSUhxSE00RVVCSVFnTUVqaHdqZXNxV0JFNDZF?= =?utf-8?B?NDZ3R0JvTTRoZENMbHU0SjhSeVFJZzZVbVNNT3psYWdWSURsUTlKUjBlYVl5?= =?utf-8?B?ZEZwK1VqcndFSVQ5aTJyR3V3aklvTW1hYURHQWtJWGo4Q0FvSFN1TW5KVnZp?= =?utf-8?B?YnFXNGxXRXZNa3drWnVCcE1lMHRFM3hTZVdUOXhHVDgzemZSVUJqa0FIQ3Jy?= =?utf-8?B?aEdoV1pZRXhXMVRVcmhZVVJsY0U0ZVlhaFFFOFQxbGs3SmplQk42d2tlVG9u?= =?utf-8?B?Si9qK2J0RnRYZWw3ZzN6ZjRxVTlpaHhKeE92RFllbnp3eVJOTEE3TnZlcW44?= =?utf-8?B?bFc2N0JWcFFtazZVU2lTeVA5ZFJ0eStVOU1oYTVCMm9vUWo2RS94MEtHcnBj?= =?utf-8?B?TCthdVZZNFdMMkJpdTd3RWQyZGFyaE5UQTc3UDVXMTYzRjJQYno4bTZqdytz?= =?utf-8?B?eFRQQ3JYUllnalRXc3UxMklYaUdBQ3BKSHcwQmlLZXU3dGEzOUZkbXhqUXU3?= =?utf-8?B?QjdJT1ZXVmJoR0UvRjF0YmNid0FxdWJNZ3dHSDYwQ280SEpPYTZ0WlF5NWgv?= =?utf-8?B?Z0FneDlLZVllZERoaEFkRHh1ekREUVhpc2JKUG9tTlE2WEk2WGRRSTladVZH?= =?utf-8?B?cVlJS3FmaWFrM0NGTmdQdWd0Q1d4bU1wd0JDMGV5MnRiaENqYVBwc2NzOG13?= =?utf-8?B?YzlnRkttSU9uWVN2Ni9KOTVURDhqSis4bDhBZkZBeW1kRU1SdDJjWXgxbTFT?= =?utf-8?B?NWVkRDFLWUJTUjkxWEd6UHNhTGRWWllHY0ZIZDlvbHc2aFg0OHdxTEdtbEsw?= =?utf-8?B?MHJQRHcyRHo3VXRvdVkwS0ErWkw4WGZGdlhxajd4K0hmcWFDeGFBSjlKUVc1?= =?utf-8?B?TUgyT2lHdUM3MHhwQ1B6T1kyZ29DdEVNNCtPT0xtYlphOTN5UXdqT1Vyc0JI?= =?utf-8?B?STEvZGFPa2VkSzlCYk1JODcxQ09zYVQxTms0UzFzTG5oeng1VmNuTUFOanZY?= =?utf-8?B?aU1jT2FzSkZkY2lIVGxnYjNoUmpxQ1JoNVBNRzN0dFNUaG1EUmNGd3YyS2Z5?= =?utf-8?B?VURNakxTZTNuaVVrUW0rZHRjVFVpWThFVUFScWJWeEdLalJvYkVTZWNnRDc1?= =?utf-8?B?QTJTNVdjRDhVZFl1eGdVTm11NUlmTmQxckNTZWhYSDYralUrNGwvQ1lJcncx?= =?utf-8?B?aDU5cGtKVGNYeWU2cnhoQldtSWNSalVCbDVXWVdVRW9sUW1kMDZTaktXMG9U?= =?utf-8?B?U25Hd20rajJkMHpqemNjbVdERlpXVlhkM3dWUnV6Q3g5VUlvVVV0K0wvQXp6?= =?utf-8?B?ajlCYlpTd2JoaEoxa3o5RVpkenhFY0Z2NjA0WlRIZExvWkREZzh5blVkME4y?= =?utf-8?B?VE84d2V6SHd5RnIxelZuS3lpdFN0K1ZFSFV5QWlYdnMxWnZJbzJiME9SZ05w?= =?utf-8?B?NDFIOGJMdlFSazVGNnZ5MDcxSTdiV1p2eit1a3ZwMEhOdVZCYjlJaFl5dzR4?= =?utf-8?B?NnBHL05abVdDRTZOV2FkczU1V1VjckExdzhlbFJua3E4ejIzOC9Id2JHQzhL?= =?utf-8?B?S01aa0tSRHUybmFsMHdwKzN2SHJnOHZNZXlIN1Rxalh6WHI3V3V6WVFhV210?= =?utf-8?B?bkovanp2ZEVZTW54Z3J6QWFybFVPTVFHVVlPTVJPUllwVnJFeDdpMUR1dnpE?= =?utf-8?B?S3hwSjJsZlV2eVYrQkQxNlBMWFZZSG5udkVXUFZBNzlSTzFMZUV0UzdhNld3?= =?utf-8?B?T2gva29OY0M2bllBSlRPYW9acEx0N3RKVGxXVHZFR0JNc04zSFNGVG00L0dl?= =?utf-8?B?cXliVzc1OU9Cc3c0SW9nRjNqTGZSLzhZRnNnMnZRZmJZSS8rMytuRUdpYjRN?= =?utf-8?B?VEtxU2NGQlBQQkNCdEc5SkorRlZFZjdTa2tUMGVlVm85YlNLZ3FwUkZzMHA5?= =?utf-8?B?QUtPOURhMDJHQ0g4c0F0amFOOFdYT05YeFVZeGVodEljRGxKSmVrQk9BeWVk?= =?utf-8?B?Q3UzTUE2dCtlT1FXZ1FRS0xUbEp3aTlxK0J1M00vTGlZVUhrN1NXcEdtR2Z4?= =?utf-8?B?M3EwNTdGZGdMQzk3WTZuYkRacDZuV2RlTnJVekJmVG1DZHBRNXpFUG5sTjlQ?= =?utf-8?B?MTdFaXhVYW1qcTFoMXFqRWo4WXcrdlowWm5xT1FJQkxSOUtHcmFPejNmY01E?= =?utf-8?B?eHc9PQ==?= 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: TYWPR01MB8362.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 28f41afe-a120-4e01-18b5-08da7ad48c1c X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Aug 2022 13:30:52.8028 (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: d+26ofWVeaxbavcqSxygcMb4525Dd+zVmA4146w+BTyX/4pTdpAn1DVEO9hlFozBtUOXMwpVYdLQN5nxGce0C1CF4ZTEVSgl8TxIekKwphE= X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCPR01MB6622 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVHVlc2RheSwgQXVndXN0IDksIDIwMjIgMTI6NTkgQU0gw5ZuZGVyIEthbGFjxLEgPG9uZGVy a2FsYWNpQGdtYWlsLmNvbT4gd3JvdGU6DQo+IEF0dGFjaGluZyB2NSBvZiB0aGUgcGF0Y2ggd2hp Y2ggcmVmbGVjdHMgdGhlIHJldmlldyBvbiB0aGlzIGVtYWlsLCBhbHNvIGZldw0KPiBtaW5vciB0 ZXN0IGltcHJvdmVtZW50cy4NCkhpLA0KDQoNClRoYW5rIHlvdSBmb3IgdGhlIHVwZGF0ZWQgcGF0 Y2guDQpGWUksIEkgbm90aWNlZCB0aGF0IHY1IGNhdXNlcyBjZmJvdCBmYWlsdXJlIGluIFsxXS4N CkNvdWxkIHlvdSBwbGVhc2UgZml4IGl0IGluIHRoZSBuZXh0IHZlcnNpb24gPw0KDQoNClsxOTo0 NDozOC40MjBdIGV4ZWNSZXBsaWNhdGlvbi5jOiBJbiBmdW5jdGlvbiDigJhSZWxhdGlvbkZpbmRS ZXBsVHVwbGVCeUluZGV44oCZOg0KWzE5OjQ0OjM4LjQyMF0gZXhlY1JlcGxpY2F0aW9uLmM6MTg2 OjI0OiBlcnJvcjog4oCYZXHigJkgbWF5IGJlIHVzZWQgdW5pbml0aWFsaXplZCBpbiB0aGlzIGZ1 bmN0aW9uIFstV2Vycm9yPW1heWJlLXVuaW5pdGlhbGl6ZWRdDQpbMTk6NDQ6MzguNDIwXSAgIDE4 NiB8ICAgaWYgKCFpbmRpc3VuaXF1ZSAmJiAhdHVwbGVzX2VxdWFsKG91dHNsb3QsIHNlYXJjaHNs b3QsIGVxKSkNClsxOTo0NDozOC40MjBdICAgICAgIHwgICAgICAgICAgICAgICAgICAgICAgICBe fn5+fn5+fn5+fn5+fn5+fn5+fn5+fn5+fn5+fn5+fn5+fn5+DQpbMTk6NDQ6MzguNDIwXSBjYzE6 IGFsbCB3YXJuaW5ncyBiZWluZyB0cmVhdGVkIGFzIGVycm9ycw0KDQoNCg0KWzFdIC0gaHR0cHM6 Ly9jaXJydXMtY2kuY29tL3Rhc2svNjU0NDU3MzAyNjUzMzM3Ng0KDQoNCg0KQmVzdCBSZWdhcmRz LA0KCVRha2FtaWNoaSBPc3VtaQ0KDQo=