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.94.2) (envelope-from ) id 1uNXwR-004Dmv-6S for pgsql-committers@arkaria.postgresql.org; Fri, 06 Jun 2025 14:21:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uNXwP-00BHcC-AC for pgsql-committers@arkaria.postgresql.org; Fri, 06 Jun 2025 14:21:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uNXwP-00BHZh-0G for pgsql-committers@lists.postgresql.org; Fri, 06 Jun 2025 14:21:05 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uNXwL-000aeP-38 for pgsql-committers@lists.postgresql.org; Fri, 06 Jun 2025 14:21:04 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uNXwL-0027za-8A for pgsql-committers@lists.postgresql.org; Fri, 06 Jun 2025 14:21:01 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uNXwK-000S1e-0r for pgsql-committers@lists.postgresql.org; Fri, 06 Jun 2025 14:21:00 +0000 Content-Type: multipart/mixed; boundary="===============7827634710822609221==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid BufferGetLSNAtomic() calls during nbtree scans. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 06 Jun 2025 14:21:00 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7827634710822609221== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgQnVmZmVyR2V0TFNOQXRvbWljKCkgY2FsbHMgZHVyaW5nIG5idHJlZSBzY2Fucy4KCkRl bGF5IGNhbGxpbmcgQnVmZmVyR2V0TFNOQXRvbWljKCkgdW50aWwgd2UgZmluaXNoIHJlYWRpbmcg YSBwYWdlIHRoYXQKYWN0dWFsbHkgY29udGFpbnMgaXRlbXMgdGhhdCBidGdldHR1cGxlIHdpbGwg cmV0dXJuIHRvIHRoZSBleGVjdXRvci4KVGhpcyByZWR1Y2VzIHRoZSBudW1iZXIgb2YgY2FsbHMg ZHVyaW5nIHBsYWluIGluZGV4IHNjYW5zICh3ZSdsbCBvbmx5CmNhbGwgQnVmZmVyR2V0TFNOQXRv bWljKCkgd2hlbiBfYnRfcmVhZHBhZ2UgcmV0dXJucyB0cnVlKSwgYW5kIHRvdGFsbHkKZWxpbWlu YXRlcyBjYWxscyBkdXJpbmcgaW5kZXgtb25seSBzY2FucywgYml0bWFwIGluZGV4IHNjYW5zLCBh bmQgcGxhaW4KaW5kZXggc2NhbnMgb2YgYW4gdW5sb2dnZWQgcmVsYXRpb24uCgpDdXJyZW50bHks IHdoZW4gY2hlY2tzdW1zIChvciB3YWxfbG9nX2hpbnRzKSBhcmUgZW5hYmxlZCwgYWNxdWlyaW5n IGEKcGFnZSdzIExTTiBpbiBCdWZmZXJHZXRMU05BdG9taWMoKSBpbnZvbHZlcyBsb2NraW5nIHRo ZSBidWZmZXIgaGVhZGVyCih3aGljaCBpbnZvbHZlcyB0aGUgdXNlIG9mIHNwaW5sb2NrcykuICBU ZXN0aW5nIGhhcyBzaG93biB0aGF0IGVuYWJsaW5nCnBhZ2UtbGV2ZWwgY2hlY2tzdW1zIGNhdXNl cyBsYXJnZSByZWdyZXNzaW9ucyB3aXRoIGNlcnRhaW4gd29ya2xvYWRzLAplc3BlY2lhbGx5IG9u IGxhcmdlciBtdWx0aS1zb2NrZXQgc3lzdGVtcy4KClRoZSByZWdyZXNzaW9uIGlzbid0IHRpZWQg dG8gYW55IFBvc3RncmVzIDE4IGNvbW1pdC4gIEhvd2V2ZXIsIFBvc3RncmVzCjE4IGNvbW1pdCAw NGJlYzg5NCBtYWRlIGluaXRkYiB1c2UgY2hlY2tzdW1zIGJ5IGRlZmF1bHQsIHNvIGl0IHNlZW1z CnBydWRlbnQgdG8gYWRkcmVzcyB0aGUgcHJvYmxlbSBub3cuCgpBdXRob3I6IFBldGVyIEdlb2do ZWdhbiA8cGdAYm93dC5pZT4KUmV2aWV3ZWQtQnk6IFRvbWFzIFZvbmRyYSA8dG9tYXNAdm9uZHJh Lm1lPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzk0MWYwMTkwLWUzYzYtNDYyMi05 YWM3LWMwNGU5MzZlNWZkYkB2b25kcmEubWUKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMv bS9DQUgyLVd6ay1EZzVYV3NfakR1aUh0NF83cnlyU1krbj12eG1IWTUxRVZxUERGc0tYbWdAbWFp bC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9lNmVlZDQwZTQ0NDE5ZTMyNjhkMDFm ZTBkMmRhZWMwOGE3ZGY2OGY3CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFj a2VuZC9hY2Nlc3MvbmJ0cmVlL25idHJlZS5jICAgIHwgMzAgKysrKysrKysrKysrKysrCnNyYy9i YWNrZW5kL2FjY2Vzcy9uYnRyZWUvbmJ0c2VhcmNoLmMgfCA3MCArKysrKysrKysrKysrKysrKyst LS0tLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHV0aWxzLmMgIHwg NjggKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLS0tLQpzcmMvaW5jbHVkZS9hY2Nlc3Mv bmJ0cmVlLmggICAgICAgICAgIHwgIDUgKystCjQgZmlsZXMgY2hhbmdlZCwgMTAyIGluc2VydGlv bnMoKyksIDcxIGRlbGV0aW9ucygtKQoK --===============7827634710822609221==--