Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w50fx-002ntZ-2Q for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 12:16:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w50fv-006dIh-1J for pgsql-hackers@arkaria.postgresql.org; Tue, 24 Mar 2026 12:15:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w50fv-006dIZ-0A for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 12:15:59 +0000 Received: from mail-australiaeastazolkn19012069.outbound.protection.outlook.com ([52.103.72.69] helo=SY5PR01CU010.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w50fs-00000000sGJ-45TR for pgsql-hackers@lists.postgresql.org; Tue, 24 Mar 2026 12:15:59 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=HE8UPgFiGqPwdAIDX+HoZxzOMPC+BXHvIMRbVuVp/WNxjuM2u+pX/Es9OJk9kLcSn1Y05OtVTofKZrHTKi2iMBjBd86Czq6tBIIMUT6VntZinD4ntou90M5ebifWcEbEWh7GnTuEqazkLvNyDStoqmf+sJ6OelAqOJz/jLJJSujKjFD7WR+oUVugrtLjjIKnG/w3h7gBJjaov7dVG8GMilBPHW2rKNUUar/9lk2Q8t0sV+C7PAKW/tW6JAu2yWi5TPY9iyyYtbnwZ2fp8qaduLPpobMuPv7QaoDHZP9IRm8dlBpTWHypdXZ40sZaoUl0yjmvqyRjQzDICw3S969oCg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=ifNSPYJu5ei8Wih8ZcP/3kRhEyoqxkJMDPE/WDEklhc=; b=yJdDoeA7kzzZE6GAuLP838IzQ1rro3hlAKMIdJYSCMduy1u7Qco+JOem2vWFYDS6RbjnqZn/dFc1q8+q+nFr8GuLkShMuM/LQzBqjl1cehYOActw5/Jm6XvpmMSTO4ReNecyLsdFVfR7ztI/nsOWlR2tHgeDwYgHEUv3cQExoUcZ7yvQkeFF1lO1VF6hXwLjVKyLQ5KeBxvjXj0z8zQOaw2Am0TwEyBVqvr9camSfesMsQmS9avLVcDW7fsq1+x2+Q9z2LfOJM8LxEmS57Tcva5pKMSuDNIxkxHufyOxS/2udILhDSSsR8LQizoIewdqNI47aZ2iM5MJOJXabzEyCA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=ifNSPYJu5ei8Wih8ZcP/3kRhEyoqxkJMDPE/WDEklhc=; b=JuGsWRIUNm+BCDIWXKEF/RDa7KkWbyT6lVvlWehihy9mVWMfPaxVCOkUe1E+cq5TAb5I6a/FJNhgKkePRph4JrFHKrgzVFLNseCZjADoolHi5OkyiIQtaVNKZeTaULrdc/Bs2qTX66r3FHbhNo+JF3V3/RPJEVKPiGDIGug7fVS3ADa+nMd6amvwae3jOd2VEuV1p9feyZv6A7kg/GtcOIr+fr8RiUOMKkyMXERKCyiaZLBuZCc8ozIbNecM79wKH75CMokAmORfaegLq72uqbtLJZ/wui/QMRbHMJCAp6kAtj9lW6NOpVFPBIZZbG9kA9evIJ1qYthJjMpdd25hcw== Received: from SY7PR01MB10921.ausprd01.prod.outlook.com (2603:10c6:10:334::16) by SYZPR01MB7728.ausprd01.prod.outlook.com (2603:10c6:10:177::14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9723.31; Tue, 24 Mar 2026 12:15:50 +0000 Received: from SY7PR01MB10921.ausprd01.prod.outlook.com ([fe80::7908:e00:4ab1:d120]) by SY7PR01MB10921.ausprd01.prod.outlook.com ([fe80::7908:e00:4ab1:d120%5]) with mapi id 15.20.9723.030; Tue, 24 Mar 2026 12:15:50 +0000 From: Japin Li To: Chao Li CC: PostgreSQL Hackers Subject: Re: heapam_tuple_complete_speculative : remove unnecessary tuple fetch Thread-Topic: heapam_tuple_complete_speculative : remove unnecessary tuple fetch Thread-Index: AQHcu1t4a8DXYRBbHEeqOu9x7FSTobW9mTAg Date: Tue, 24 Mar 2026 12:15:50 +0000 Message-ID: References: In-Reply-To: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: SY7PR01MB10921:EE_|SYZPR01MB7728:EE_ x-ms-office365-filtering-correlation-id: 6347a46e-eadb-440f-d2e0-08de899f16ca x-microsoft-antispam: BCL:0;ARA:14566002|461199028|6072599003|15080799012|31061999003|14091999006|19110799012|12121999013|8060799015|8062599012|22091999003|24121999003|3412199025|440099028|12091999003|102099032|40105399003|52005399003; x-microsoft-antispam-message-info: =?utf-8?B?dXhJbjNhcTIyQ3ZRMWJEbDhJb0VxcXgybGFmaXJyT0pKL0RCenJwNmQvbm5X?= =?utf-8?B?UkV2WWg2US91SjUrQnNXeVZWd20xTGp5L2poamRON3gzalYrQjUxR2tmc25B?= =?utf-8?B?VStyNk9GdkttL04vU254SDBFeGZWVjZpNWJrQUZtOW02MS81dmxDNlQ4SGtW?= =?utf-8?B?Q0hBMER5dkJzWmJMNGJmbkN0Wm4xK2VHTFBkRDZYWXcwY1E5U0JOVVIxQ05M?= =?utf-8?B?SVVZNDZqaXpGaGI4WXpkQUJrSXJPUjkzZ1RGTi85SnNlWFNOeVRPWjJGbkxt?= =?utf-8?B?UWM5c3lGMGErVTU5TnNCVi9wbUVDMHZHU2lkTDREZWZMMmM3VStIUlh6T1E3?= =?utf-8?B?NGk0ZTYyK1JWZUJva0xtUzBjRDQ3N0kvYnUrV1dlM0I2SXV6NXFJN1FXcTdo?= =?utf-8?B?TGpIaVN0L0EreW4zU1FvNFB5STdZeVhYZFNIUkxrbzNDV093Tm4wSi8ycmp6?= =?utf-8?B?eVR0VVg5a0ZJdWYzQjZzTHZreVh6b3NkSVBRckZnMktmYWZneU9wdnFCQlBs?= =?utf-8?B?N2N4K3NNYjU1Qmkyc0lqU1JlSllWOHd3ZE5hejZMcExlc0ZhM1JHZDh1dmg0?= =?utf-8?B?MGZ3TFZZQ3FTRDhTUkFlSjRkMHEzNHR6OXljdmtEc1hmZlFnL254bU5lcEZE?= =?utf-8?B?TGc2a0M3bzZ6czhrcis0czJ2QWFZaUhUUWMvY3c1c0dPaEVxam15UFNFWnpj?= =?utf-8?B?c1ZNdGpBWlU4Rm5rajFaMlJYMi80dThYS0RnQVE2V1JRMTNHU01yakFtQXUx?= =?utf-8?B?MjdUbTdvbEVlMzVwa2dFTlVUakRlV1BwMyt4ajJhdEdva3FYVGJXd2hYYUF6?= =?utf-8?B?dHlzU1lGSVQ3R0dMZWI3Qk9waWd3WFV2MkdRcmVZOE43ak55SW9zRXBkcFhK?= =?utf-8?B?TU1kSXA1eTlFSnVsN2FHNGg1dTdDZWw4RUlhaXBNRGlWUGdkQkYvNUNKTE90?= =?utf-8?B?cEFQT2JmWGs3WERXdC9tRzJ5NklhdjBNMmh2eFhveEZObytRZkZ5aGloREJI?= =?utf-8?B?bElXQUc2RE5LQmtWcUorVFJIVUJFZnFRcjZ4dHBZdm5aWk9IYVFjSy9zRnFN?= =?utf-8?B?UVVDRGxTZVJtUWQ0STdOTFFSVHJ3SFNUL2ZXWXQzUTM5M2N6d2kwakc0c3hR?= =?utf-8?B?c09RZlEzQlVKRVJTZUs1WC9XdG50Q2VTWTdRQ0xjZEEwcVdlZWFYbzlKYU9l?= =?utf-8?B?Z0RGOUhQSVJxU3hkME4zM1ZYSUZYQ0ZZVTV2VWcyUk1Ga3NqWEZUaFhad1Vp?= =?utf-8?B?YktlMXdDWlRBLzlvdmtpM01JRnU3a0Z1NXVyYkpwMlBFSDRwdU5XU0hmMlcw?= =?utf-8?B?MU9IUWVsWTU2Z1RiN0t6MVhNaTUwWjc1dTFqVENUT1BjdjNkakI4VmhUeVNC?= =?utf-8?B?MVhGMlNJRnA3MXEwbTdNMW42Rys2WFdLVlF5enEwS2czNUU3K3Fod2o1eDVp?= =?utf-8?B?b1VibFdEU1dwempOeHdJcG0yS2hPOCtGQmJtRTEyRThkZGRDWXQxNVN5YjRG?= =?utf-8?Q?gHWMhc=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?NVdMTkM5OVkzUnpLSUhzN1VjV1NIOXlpbVZWb1JQMm9WU0h0VzNVWlhQZWl2?= =?utf-8?B?d2ZkMjFCaHN6YndpWWd1S1lNNGhEZ3FsMXlXV0Z2cWh6SXNycHhzeW1BKzFT?= =?utf-8?B?RS9JQzBpeHVyVjduY2QwU2hDSnNFeENHK1RHK0U2bXlzL2dlRlZpcXhFTmMv?= =?utf-8?B?YStScjN2ZEFLV0QydGZmQSs0dnFaaXBRMmlhUUd6YTF6UXRaWFFkR0FuRjNL?= =?utf-8?B?NzQ4bWszKzg2VTBKNlNKalpReWp5bkZRY2FaSTRKZk5MbytXYWYvNWZXTDBS?= =?utf-8?B?Ry9VeDIxVXhmMWJZV2dhTzdkV3daQWdlQTJzUmEySU5adnVBTGdlSklPOUhN?= =?utf-8?B?ZjVVUzZqOU5VZnNmN2YycHhSS2diaUhvVDk0eHlrUE9ITUxDTkJOSGZjbFo4?= =?utf-8?B?VXYzY3dKYytZT0ttdkJRQ0tBWTV2ZzJwNlZMTWUya1g3SEhQa1hkbWMxcTNw?= =?utf-8?B?TjlCOWtrc213QVUyWXpGU1RzcDJvSUFWb2hyR2czaUd5MFNIZTdRWS9sMDBs?= =?utf-8?B?UThiZUZsU0FzbU1xcWVsaTczaU1RaU43dWxyVGY2bHA5TjZ5dHZBd1ZNdXd6?= =?utf-8?B?WmtkMUp1UmZPbC90aGJ6KzVYenBZZU15NW1PdmxOMURIQ2o2aWw3QjdjNjJl?= =?utf-8?B?QnZBNUs3bmVkU3R5U0ZmeERNczI2eDV4V0ZhZ2FwNHZpK0RFTW9iczhONzh3?= =?utf-8?B?NFZneGVud2FBZWVXN3JkTzlXWisxVldvM3hhNWREWlZVNEZXQnFHYkk1T0hl?= =?utf-8?B?NkVCNU5Ocm1HQ29BRkN2UHhiL2NTM2ZCUVhTNjhtcnVhNVl6QXZVRVNob1h2?= =?utf-8?B?Y1k3RU9zL1RkTktON2ZKMnBDTXpyS0hWOHFZaDNTVEdqUHlVbW5HaURHSGpL?= =?utf-8?B?eWU3YnpaRDhacjJyY2ppcWxtWGhTZEgxNi9jczlxOW5HTjZ0YWZmOXIyUTk1?= =?utf-8?B?V01lSjUwWDFrL1NKYVlORGF2ekplVXdYRWlXd2c3bnI2bGtvb04yOHE2VUpa?= =?utf-8?B?NFlOMkJkM05wMlp6cWFTQjJBTk5CeVdKRThZZWlwVFlEL29zMEUzUmhwTnJa?= =?utf-8?B?QjlQYWh5cVZTZmdaMzNFZDFNN3BhVG92ZmRZWlQzTnc3MHdrSzdwcWMwVzh0?= =?utf-8?B?RE9FbS9mMnBIWHlVMmhHVERVRVM0c3VXMW5lMngvM2crcTd2R3Y3cDloUSty?= =?utf-8?B?NDBMVmFJSXAya1BjVms5bWx4RTVpNU9YMm1JdXZnaWczTHRkdEcwSWlKc3lr?= =?utf-8?B?L0xHMXJoS1RyTHJjbG84Q044NWRpUWhjYklTMVNSS2N5N0oxTU9sbjkvR2RT?= =?utf-8?B?TS9XVjBYVHdpaG0vOFJadTdyOVJYNWNSWTVLQlR1clZXYlRadi9nbGg2ZUZ1?= =?utf-8?B?NWZVbWZDMHBkdkNVcjA2YUltc2FXUGd0dmVmS2kyUjYrUTdmYVJzcUpDaFAz?= =?utf-8?B?ei83bWUyYTNkemo4amEwUEdRaXRGemNRTXVaWHJ0UW9XSFRrZUg1Y3JCTWl2?= =?utf-8?B?NkdpU0gySThNWFVnOWF3UE1XV3lWSy9qRkExa1hzcno5cnYzQ0ptTW1ZZ1dX?= =?utf-8?B?VkpOWVZWcTFycXFrTTV1WEtjbTNpSEJLQWZtYXV4ZW9hblI2bzU0NGN0MHpD?= =?utf-8?B?SUlsMU9vZ21YbEZrVG9PMmg5WVQ3TkhYWVNYdlJ5WDhPSEdHeWhZYWhXcXR6?= =?utf-8?B?RElKa2Y2Q2NLdjV6a0g0ZEhxVVg4akdHTWVIK3VVU2lXNXZEQ3ZWMUwreTdL?= =?utf-8?B?VVlSSEhIWHZKWndaZG5aL3NMV0ZUeDFvc0JxWjcyY2pYYVhTYmtxblFocnp6?= =?utf-8?B?Vy8rdzZGeDFiY28vOXUya3pwTE1yTUZKck5zZ0ZOT256Q3l3Z2NvdG0waFRI?= =?utf-8?Q?WR2dVz3mKNva0?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-9412-4-msonline-outlook-feddd.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: SY7PR01MB10921.ausprd01.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 6347a46e-eadb-440f-d2e0-08de899f16ca X-MS-Exchange-CrossTenant-originalarrivaltime: 24 Mar 2026 12:15:50.7829 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: SYZPR01MB7728 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk DQo+IOWcqCAyMDI25bm0M+aciDI05pel77yMMTQ6NTfvvIxDaGFvIExpIDxsaS5ldmFuLmNoYW9A Z21haWwuY29tPiDlhpnpgZPvvJoNCj4gDQo+IO+7v0hpLA0KPiANCj4gV2hpbGUgcmV2aWV3aW5n IGFub3RoZXIgcGF0Y2gsIEkgbm90aWNlZCB0aGlzOg0KPiBgYGANCj4gc3RhdGljIHZvaWQNCj4g aGVhcGFtX3R1cGxlX2NvbXBsZXRlX3NwZWN1bGF0aXZlKFJlbGF0aW9uIHJlbGF0aW9uLCBUdXBs ZVRhYmxlU2xvdCAqc2xvdCwNCj4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdWlu dDMyIHNwZWNUb2tlbiwgYm9vbCBzdWNjZWVkZWQpDQo+IHsNCj4gICAgYm9vbCAgICAgICAgc2hv dWxkRnJlZSA9IHRydWU7DQo+ICAgIEhlYXBUdXBsZSAgICB0dXBsZSA9IEV4ZWNGZXRjaFNsb3RI ZWFwVHVwbGUoc2xvdCwgdHJ1ZSwgJnNob3VsZEZyZWUpOyAvLyA8PT0gdHVwbGUgaXMgbm90IHVz ZWQNCj4gDQo+ICAgIC8qIGFkanVzdCB0aGUgdHVwbGUncyBzdGF0ZSBhY2NvcmRpbmdseSAqLw0K PiAgICBpZiAoc3VjY2VlZGVkKQ0KPiAgICAgICAgaGVhcF9maW5pc2hfc3BlY3VsYXRpdmUocmVs YXRpb24sICZzbG90LT50dHNfdGlkKTsNCj4gICAgZWxzZQ0KPiAgICAgICAgaGVhcF9hYm9ydF9z cGVjdWxhdGl2ZShyZWxhdGlvbiwgJnNsb3QtPnR0c190aWQpOw0KPiANCj4gICAgaWYgKHNob3Vs ZEZyZWUpDQo+ICAgICAgICBwZnJlZSh0dXBsZSk7DQo+IH0NCj4gYGBgDQo+IA0KPiBJbiB0aGlz IGZ1bmN0aW9uLCB0dXBsZSBpcyBub3QgdXNlZCBhdCBhbGwsIHNvIHRoZXJlIHNlZW1zIHRvIGJl IG5vIG5lZWQgdG8gZmV0Y2ggaXQsIGFuZCBzaG91bGRGcmVlIGlzIHRodXMgbm90IG5lZWRlZCBl aXRoZXIuDQo+IA0KPiBUaGlzIGFwcGVhcnMgdG8gaGF2ZSBiZWVuIHRoZXJlIHNpbmNlIDVkYjZk ZjBjMDExLCB3aGVyZSB0aGUgZnVuY3Rpb24gd2FzIGludHJvZHVjZWQuIEl0IGxvb2tzIGxpa2Ug YSBjb3B5LXBhc3RvIGZyb20gdGhlIHByZXZpb3VzIGZ1bmN0aW9uLCBoZWFwYW1fdHVwbGVfaW5z ZXJ0X3NwZWN1bGF0aXZlKCksIHdoaWNoIGRvZXMgbmVlZCB0byBmZXRjaCBhbmQgcG9zc2libHkg ZnJlZSB0aGUgdHVwbGUuDQo+IA0KPiBJIHRyaWVkIHNpbXBseSByZW1vdmluZyBFeGVjRmV0Y2hT bG90SGVhcFR1cGxlKCksIGFuZCAibWFrZSBjaGVjayIgc3RpbGwgcGFzc2VzLiBCdXQgSSBtYXkg YmUgbWlzc2luZyBzb21ldGhpbmcsIHNvIEnigJlkIGxpa2UgdG8gY29uZmlybS4NCj4gDQo+IFRo ZSBhdHRhY2hlZCBwYXRjaCBqdXN0IHJlbW92ZXMgdGhlIHVudXNlZCB0dXBsZSBhbmQgc2hvdWxk RnJlZSBmcm9tIHRoaXMgZnVuY3Rpb24uIEFzIHRvdWNoaW5nIHRoZSBmaWxlLCBJIGFsc28gZml4 ZWQgYSB0eXBvIGluIHRoZSBmaWxlIGhlYWRlciBjb21tZW50Lg0KDQpNYWtlcyBzZW5zZSEgQWxs IHRlc3QgY2FzZXMgcGFzc2VkIHdpdGggbWFrZSBjaGVjay13b3JsZC4NCg0K