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 1oimUh-0007dE-VV for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Oct 2022 00:54:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oimUg-00059o-Eg for pgsql-hackers@arkaria.postgresql.org; Thu, 13 Oct 2022 00:54:38 +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 1oimUf-00059f-Vt for pgsql-hackers@lists.postgresql.org; Thu, 13 Oct 2022 00:54:38 +0000 Received: from esa3.fujitsucc.c3s2.iphmx.com ([68.232.151.212]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oimUc-0008I7-Do for pgsql-hackers@lists.postgresql.org; Thu, 13 Oct 2022 00:54:36 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1665622474; x=1697158474; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=nMW4r9+3jaNeh5HyWw86GIM0xko4vLeUspeJNykiNSo=; b=ouS1FV6/4GgQD6iH82K1lE75/SUreLSzo8RfAkjI77hZwcoResklhJ+4 IS1Vn9/BHQcd8gXnEEbQIQpA08pBWfMGF97+tXTH+8+d0AV8ZSWYNM50N TmBA/izYzoprTbE491yyx2Pa7IxgHgpY4guYIIAnEl3EhJmxq8S99bd7I lnvjtPIq6q5lWJzHt3qoXVTQBBAdwprNKG+D6hjgj+0jHKfjRElI2Hrkd 2ADDDoHDODx7ZMMAmygnxYrpH4+1k5kJ/NKIoOIhY26QXvr4LOvlN+9+Z 073Ra15NRSB+x96ZdU5rUhssHO8VWHmeo7ge+2p6bBTbdsGBmDnMfl4cj w==; X-IronPort-AV: E=McAfee;i="6500,9779,10498"; a="75462766" X-IronPort-AV: E=Sophos;i="5.95,180,1661785200"; d="scan'208";a="75462766" Received: from mail-os0jpn01lp2107.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.107]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 13 Oct 2022 09:54:30 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=cESQuHCNlalaJ7/+TmAM5EWTUdLarAnAWr07QiAV/jiTEv7aGq1iYaHGWl6y6Hn/Ay67PrUzpAp/IYgl05Yu5NI+xkEM92YLySXUROEDBbG/9uG/80xfAvBgQmGXtL7cOToZ6pcqNjDemEDh36pRz1qzrO/iZdA0ASeGzmAAJ5HEYgpm0n5VuEHPd8gusVYEX5qw4krVARfVSi8Tc2ur23W5KhszUH+NJpdqqwiR+gGyY1xKfY/m2pfHljelukameXxbahcLkpORjsYdqYpIfSMl2FWRWxAw7+Hsx3nnrXVK9ijxBJBOAdYgxblDpfsJUf/iAjb/4QFVPArQQtnSWw== 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=nMW4r9+3jaNeh5HyWw86GIM0xko4vLeUspeJNykiNSo=; b=a5kH4NxK5FZnU2jFrrDN7DDLuGuRoaE3BLwbBaGNRNoRfu0XihJwZH1vARLZHz+r2JmDmezsTxERTVB8v/N3WHabrfMaN3A0CemAm1zj5oiwF+ohXeeOXxE8QAbmyeSlYAntZOUFAF4/rTXpgg/B6cKcs6rJf5iRN1uKLBInTvF+Z16g0MVI4+icLzhRRIooEHeRhEu3hT7oPadS2mgEOBq/CwP4XT5GOIvXH8uVZDj+6qNy+It+KX3oBm0QKtPN0YM4dhRWNAvfbYAO5fLzr3DUeULzKRPCm/FqeoxmwDeHlqn90onMjvTCuFHkPSek2utQTn3NDNy9IdpyJbEpfw== 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 OS3PR01MB10315.jpnprd01.prod.outlook.com (2603:1096:604:1df::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.5723.26; Thu, 13 Oct 2022 00:54:28 +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.5723.026; Thu, 13 Oct 2022 00:54:27 +0000 From: "kuroda.hayato@fujitsu.com" To: =?utf-8?B?J8OWbmRlciBLYWxhY8SxJw==?= CC: Peter Smith , Amit Kapila , PostgreSQL Hackers , "wangw.fnst@fujitsu.com" 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: AQHYlfR9LEBKLYEcwkKxapLlGSf5sq2Ds22AgAGwZACAAVjRgIAAp0wAgAFDuYCAAfjlAIAVnJQAgAUWeQCAByaZAIALYnOAgBq6wgCADKDWAIACYhAAgAWzuYCAARsrgIAAIqYAgAKxIACAANO+AIAIwQnggAJOpQCAAKGfAIALmQ4AgAXBt3CAAJWcAIAA7FswgAEKjwCAAGZWoA== Date: Thu, 13 Oct 2022 00:54:27 +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?Yy1hYjRkLTNiMGY0ZmVjZTA1MF9TZXREYXRlPTIwMjItMTAtMTNUMDA6NTA6?= =?utf-8?B?MjVaOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0?= =?utf-8?B?ZmVjZTA1MF9NZXRob2Q9U3RhbmRhcmQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEt?= =?utf-8?B?ZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX05hbWU9RlVKSVRTVS1SRVNU?= =?utf-8?B?UklDVEVE4oCLOyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9TaXRlSWQ9YTE5ZjEyMWQtODFlMS00ODU4LWE5ZDgt?= =?utf-8?B?NzM2ZTI2N2ZkNGM3OyBNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1h?= =?utf-8?B?YjRkLTNiMGY0ZmVjZTA1MF9BY3Rpb25JZD0xZDE1ZDVjZC0xN2FlLTQxNTkt?= =?utf-8?B?YjczZS0wM2M1Y2QwMmU1YzQ7IE1TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00?= =?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_|OS3PR01MB10315:EE_ x-ms-office365-filtering-correlation-id: d5ab4e5b-d815-41e0-ac4d-08daacb57b04 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: rl/5j/mtvDNCX0qNerhV0PTVWOH8GwokInh5QUKFVnYLuO0N4WRLTAQSbxl2X2UXhwPu3lJs/Zv4G69KFHdexlEGrhQnuWKO98Q6B7miCWi/G/PYcA1N7SkSfPRxh+XWSoeteom28GDX8Hu3yp/N8nYKhcA1jT9EIMiU/pVR7svIgZjccmrvZNLNLSDvMgHa8ZJvM94pfSL0dimZGvcSqMCj5jrcSJGV68qDAIJGdNlOHcTHdPz2qELBUpXP2eJiHXkRGhwy2vWrMOedGBrqcNY3fiE1dCBc/dqQlcdb61x1NADWjxH5Ocmq6hcBhGmpS5TF5OQCGqCO2nCP4U3e2iPFNOdDCO3xPsSglmS2CTsdqK+NKOi/WIDO7kdxGTnv/2YPLMwNcXY5s3v7ZfTwWgYu7EUHczd2pt9/IIKjMer+0XSnkDKtxw3gyiDxob0JVqgSlQSVBzOIgWPX2Ej/yFFae9y0ouHWDBaQLZKOqgILjkGu7NW09p6RWgW+uWOb2opaZdcMJwSTjDOFU4n/CfBqmg7C3iKq4oUOqQi9/YQZ3PKV0RtiD989zJ2BnsgJVY0xsji40+LGHCLWRu7dABLzNuarWuHHy7aDpGa9MyswfMgNetT2GxVqpfUZRwLqQWwOsA9ZekyrgqSip5FnzZKd2RetPJARXuOIjBfHElQWJCGU6YcNlSnt4Lc5NGRNFqhQwtnFMUd1YLgNoYj3nIjZERiSGfyu63m6MEdcWz+Y+TFT3GoDiLEbv2B+De6x9nKDZ5WkHgjhgqCMLX75HW1/IMrXjX/wLSJZSZtDQoE= 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)(396003)(39860400002)(366004)(346002)(376002)(136003)(451199015)(1590799012)(8936002)(478600001)(9686003)(52536014)(26005)(66556008)(2906002)(86362001)(64756008)(82960400001)(76116006)(66946007)(66476007)(66446008)(7696005)(6506007)(41300700001)(4326008)(38100700002)(558084003)(33656002)(107886003)(8676002)(83380400001)(54906003)(6916009)(186003)(316002)(85182001)(38070700005)(55016003)(122000001)(1580799009)(71200400001)(5660300002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?TFdWRWoxVGxmWnlNaHRpbUZKcmE4Z1JWZmV3WGZJaC8zYm9HUnVKY0h3VkRs?= =?utf-8?B?bW9VZ3JHVndVTS9NdllyTkJuYllRcGhhUkhCa2h3VmVVSnpteFIzRTZPTkQ0?= =?utf-8?B?YUJsSjJtRCtuMzBkZ2kzaDF3UHRlWWg2RXprT1cydVpGemxiSnJQd01rcE1x?= =?utf-8?B?S3hDSzUxQVRwMHdSQ2pJcXNiTkEwYlYwU2h0bGFVdmtCV2Q4cXlpNm5MSm95?= =?utf-8?B?Wk1qaUVxNFA4d3ArUjlLYVhhMjd3ZGVYU3RlWkhTSGIzVnZCZGQyd3hhUmkv?= =?utf-8?B?dmhIa3k1a0kxSjhtWndPb2ZJbFA4bjAyaXU4T0h2TFVWa0gwRlI2UElFbUhP?= =?utf-8?B?cmtoMzUxY0hKUlBBa1M3a0Z4eUVzMXRTZlYvbUo5MHpLNnQ3VTI4cnljTFBh?= =?utf-8?B?VUxjTVFCcUhiTmlhK1IzS25rNUNQVHcyYUU1NU9renBPekdRTFNpTDl3bHFW?= =?utf-8?B?YmlucmVPWWk4OWZRT2szMmlMSHlEUElTeFlRY3E0Uk82MS9kcDlxNXF1V1o1?= =?utf-8?B?S25NWlEwdnd4UUFYM1ZPdmoxSWladllpc3BLWnQzMThBNjFrc3A1bG5PYUpi?= =?utf-8?B?UytHRHo2WENtcXQraXJZbjh5Tm04dk1JZVFBaU9TU0J6eHdzY1V3NytzdDJH?= =?utf-8?B?ZkN3ME8vTTVzQTk0MWZUS1dTVFNRQUlmRzZDMm1hUTZFUzV5Y1FMUE1jSGd2?= =?utf-8?B?UGcxcVpKWXRBamNnNTZOODJpNitIOXFsWDh6Y2E5RFE4Tk9udEdTTTBISVR5?= =?utf-8?B?ZFZDMi9FcnArNHQyMVErY2dGb0FPM3pORUJsRTgzWXZ5d2xCY1FMeXh1ajhD?= =?utf-8?B?cDJNWWx1V0hUWnllRVkwUFI2NmcxU1FBZnU4WEtvWkR2aW92OTVMOG1GRmFR?= =?utf-8?B?djZ5SitzYTQvQ1oyQU1WeitFZzdyUE1EMWtpbGZkZEJOd2l3d1BGdVB0Y0pk?= =?utf-8?B?SENLdXNSWklKL2tjVjBPcGFvcmRYR2FVUXpSZm9qQldlc2YwRDVmRkFSU0dV?= =?utf-8?B?Q2czQnJWT1pGS2tzcjFhVHRZVXlUK3FZejZPc1ptMFFIYzBlQnpHMEo3Rjg3?= =?utf-8?B?LzhJOVJ5WVpQTWFNZUpmb3plYi81REtTcUhFWStPQ3JnVTFjQzkrV01FOFI2?= =?utf-8?B?ZFcyOTBpVmVYbllvZC9WRkhCaXg5MHdGVmhSOHQvakEzYy80bXI2SERKZHZE?= =?utf-8?B?eS9yMmdUb09paDJzS05qaThybHRsRUtvM0NtVkRteWR0b0J5ZzE5WHNJem92?= =?utf-8?B?RE1hd0p1ZmNreEpUcDNuQjBVTllITVFKYm5paGxkTEI4N3ZaR3dHSjhRVFdi?= =?utf-8?B?cmhVYXJSVW4yeGkzMDFsWlFIWUZ2N0YyTmRrZmFrK3JocjB6MmUyUjgyaWtl?= =?utf-8?B?T1ZRM2dqZGpFYm8zdUptKzAzaGxqQzZVZUtiYjlGaXhrSVBZbmRYNzJoSFBH?= =?utf-8?B?Nm9PczJEME80RHkzYk1zOTZCcUo1Z3hQOU1rRDJoWGt5a1lwQ1Z2MVZqaFd3?= =?utf-8?B?YjI1T2NoUVNrUy9tR0pkZTUwMStjWHNWNG1xMTh6N21KSW1mQzU1dmZ2Z3cx?= =?utf-8?B?YzNZeFQ0VnUrS0lJWVI5ZTYzNkdOSzVoVWN2YTVuTVBXay83SzlpcUNCeElw?= =?utf-8?B?SGc3SUQ4dGduckNwaUJSaVJnWSt4YWc4eHh2VjB2VE5OM0RsOHczRzhQcS90?= =?utf-8?B?ZHFPbzJpeEhIMFFEeGFkL3RuMnUxS1FGM3RtbGtzN0l2TWlKN2o3MVFScmg1?= =?utf-8?B?Y1F5SHBYKzBqS0U1TmZEcENZcHUrUlZFbE9panBRc1ZOaFBYYXcrUWxQZnpR?= =?utf-8?B?SlQ5VHhJcGZCZUpOaDh4S0lwSU1jVVk5Wm5tRXpIRW9UOHYvV3ZSTThMK0lU?= =?utf-8?B?VmN0UnBiTFYrTDRLTjZKMVREVkpUazhFUWpBMnFVWFV1ejU4c29YckVuZmVn?= =?utf-8?B?ME9UaFJHUUVHSmtWcWxGbSs3dFA4RkZzb3N4TTBpcGFhMUhESDJsSHpvM0VW?= =?utf-8?B?SHUwSzlxQ0ZZc3Ruc0ZQZUdqYWt1WFRJNmNvamMrVXVSU1cxRXdPNGtRR2xa?= =?utf-8?B?cURBalhiNkRSRklwS1FqRUI3UitET1YxampUZkhLMEYvMytPa1RnVXdBMVRB?= =?utf-8?B?NzlBa21NU3JRMEJpd01Ea2s0SlpZRkV4cVZURzlhVFlUYmZybEp2RlpuNHpv?= =?utf-8?B?ekE9PQ==?= 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: d5ab4e5b-d815-41e0-ac4d-08daacb57b04 X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Oct 2022 00:54:27.8683 (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: f/Z25vnGPdF65jYvFpKGuc1s9nGgvTw11Z5ILAg5DsBUkfaW0v179SAYgfMruhigKvxYiqaJOUFrmLxX4oMQExZn3FRMKR0eQJDw0EPXIxs= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS3PR01MB10315 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk RGVhciDDlm5kZXIsDQoNClRoYW5rcyBmb3IgdXBkYXRpbmcgdGhlIHBhdGNoIQ0KDQpJIHRoaW5r IHlvdXIgc2F5aW5nIHNlZW1zIHJlYXNvbmFibGUuDQpJIGhhdmUgbm8gY29tbWVudHMgYW55bW9y ZSBub3cuIFRoYW5rcyBmb3IgdXBkYXRpbmcgc28gcXVpY2tseS4NCg0KDQpCZXN0IFJlZ2FyZHMs DQpIYXlhdG8gS3Vyb2RhDQpGVUpJVFNVIExJTUlURUQNCg0K