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 1uyGG9-005lTj-9u for pgsql-committers@arkaria.postgresql.org; Mon, 15 Sep 2025 20:57:13 +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 1uyGG6-00DgEZ-1u for pgsql-committers@arkaria.postgresql.org; Mon, 15 Sep 2025 20:57:10 +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 1uyGG5-00DgER-Qm for pgsql-committers@lists.postgresql.org; Mon, 15 Sep 2025 20:57:10 +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 1uyGG3-000bSK-2I for pgsql-committers@lists.postgresql.org; Mon, 15 Sep 2025 20:57:09 +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 1uyGG3-001dVx-Kg for pgsql-committers@lists.postgresql.org; Mon, 15 Sep 2025 20:57:07 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uyGG2-000t6C-0P for pgsql-committers@lists.postgresql.org; Mon, 15 Sep 2025 20:57:06 +0000 Content-Type: multipart/mixed; boundary="===============7279433801125052231==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Teach nbtree to avoid evaluating row compare keys. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 15 Sep 2025 20:57:06 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7279433801125052231== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGVhY2ggbmJ0cmVlIHRvIGF2b2lkIGV2YWx1YXRpbmcgcm93IGNvbXBhcmUga2V5cy4KCkFkZCBs b2dpYyB0byBfYnRfc2V0X3N0YXJ0aWtleSB0aGF0IGRldGVybWluZXMgd2hldGhlciByb3cgY29t cGFyZSBrZXlzCmFyZSBndWFyYW50ZWVkIHRvIGJlIHNhdGlzZmllZCBieSBldmVyeSB0dXBsZSBv biBhIHBhZ2UgdGhhdCBpcyBhYm91dCB0bwpiZSByZWFkIGJ5IF9idF9yZWFkcGFnZS4gIFRoaXMg d29ya3MgaW4gZXNzZW50aWFsbHkgdGhlIHNhbWUgd2F5IGFzIHRoZQpleGlzdGluZyBzY2FsYXIg aW5lcXVhbGl0eSBsb2dpYy4gIFRlc3RpbmcgaGFzIHNob3duIHRoYXQgdGhlIG5ldyBsb2dpYwpp bXByb3ZlcyBwZXJmb3JtYW5jZSB0byBhYm91dCB0aGUgc2FtZSBkZWdyZWUgYXMgdGhlIGV4aXN0 aW5nIHNjYWxhcgppbmVxdWFsaXR5IGxvZ2ljIChjb21wYXJlZCB0byB0aGUgdW5vcHRpbWl6ZWQg Y2FzZSkuICBJbiBvdGhlciB3b3JkcywKdGhlIG5ldyBsb2dpYyBtYWtlcyBtYW55IHJvdyBjb21w YXJlIHNjYW5zIHNpZ25pZmljYW50bHkgZmFzdGVyLgoKTm90ZSB0aGF0IHRoZSBuZXcgcm93IGNv bXBhcmUgaW5lcXVhbGl0eSBsb2dpYyBpcyBvbmx5IGVmZmVjdGl2ZSB3aGVuCnRoZSBzYW1lIGlu ZGl2aWR1YWwgcm93IG1lbWJlciBpcyB0aGUgZGVjaWRpbmcgc3Via2V5IGZvciBhbGwgdHVwbGVz IG9uCnRoZSBwYWdlIChvYnZpb3VzbHksIGFsbCB0dXBsZXMgaGF2ZSB0byBzYXRpc2Z5IHRoZSBy b3cgY29tcGFyZSwgdG9vKS4KVGhpcyBpcyB3aGF0IG1ha2VzIHRoZSBuZXcgcm93IGNvbXBhcmUg bG9naWMgdmVyeSBzaW1pbGFyIHRvIHRoZQpleGlzdGluZyBsb2dpYyBmb3Igc2NhbGFyIGluZXF1 YWxpdGllcy4gIE5vdGUsIGluIHBhcnRpY3VsYXIsIHRoYXQgdGhpcwptYWtlcyBpdCBzYWZlIHRv IGlnbm9yZSB3aGV0aGVyIGFsbCByb3cgY29tcGFyZSBtZW1iZXJzIGFyZSBhZ2FpbnN0CmVpdGhl ciBBU0Mgb3IgREVTQyBpbmRleCBhdHRyaWJ1dGVzIChpLmUuIGl0IGRvZXNuJ3QgbWF0dGVyIGlm CmluZGl2aWR1YWwgc3Via2V5cyBkb24ndCBhbGwgdXNlIHRoZSBzYW1lIGluZXF1YWxpdHkgc3Ry YXRlZ3kpLgoKQWxzbyBzdG9wIHJlZnVzaW5nIHRvIHNldCBwc3RhdGUuc3RhcnRpa2V5IHRvIGFu IG9mZnNldCBiZXlvbmQgYW55Cm5vbnJlcXVpcmVkIGtleSAoZG9uJ3QgYWRkIGxvZ2ljIHRoYXQn bGwgZG8gdGhhdCBmb3IgYW4gaW5kaXZpZHVhbCByb3cKY29tcGFyZSBzdWJrZXksIGVpdGhlciku ICBXZSBjYW4gZnVsbHkgcmVseSBvbiBvdXIgZmlyc3RjaGFuZ2luZ2F0dG51bQp0ZXN0cyBpbnN0 ZWFkLiAgVGhpcyB3aWxsIGRvIHRoZSByaWdodCB0aGluZyB3aGVuIGEgcGFnZSBoYXMgYSBncm91 cCBvZgp0dXBsZXMgd2l0aCBOVUxMcyBpbiBhIGxvd2VyLW9yZGVyIGF0dHJpYnV0ZSB0aGF0IG1h a2VzIHRoZSB0dXBsZXMgZmFpbAp0byBzYXRpc2Z5IGEgcm93IGNvbXBhcmUga2V5IC0tIHdlIHdv bid0IGluY29ycmVjdGx5IGNvbmNsdWRlIHRoYXQgYWxsCnR1cGxlcyBtdXN0IHNhdGlzZnkgdGhl IHJvdyBjb21wYXJlLCBqdXN0IGJlY2F1c2UgZmlyc3R0dXAgYW5kIGxhc3R0dXAKaGFwcGVuIHRv LiAgT3VyIGZpcnN0Y2hhbmdpbmdhdHRudW0gdGVzdCBwcmV2ZW50cyB0aGF0IGZyb20gaGFwcGVu aW5nLgooTm90ZSB0aGF0IHRoZSBvcmlnaW5hbCAiYXZvaWQgZXZhbHVhdGluZyBuYnRyZWUgc2Nh biBrZXlzIiBtZWNoYW5pc20KYWRkZWQgYnkgY29tbWl0IGUwYjFlZTE3IGNvdWxkbid0IHN1cHBv cnQgcm93IGNvbXBhcmVzIGR1ZSB0byBpc3N1ZXMKd2l0aCB0dXBsZXMgdGhhdCBjb250YWluIE5V TExzIGluIGEgbG93ZXItb3JkZXIgc3Via2V5J3MgYXR0cmlidXRlLgpUaGF0IG9yaWdpbmFsIG1l Y2hhbmlzbSByZWxpZWQgb24gcmVxdWlyZWRuZXNzIG1hcmtpbmdzLCB3aGljaCB0aGUKcmVwbGFj ZW1lbnQgX2J0X3NldF9zdGFydGlrZXkgbWVjaGFuaXNtIG5ldmVyIHJlYWxseSBuZWVkZWQuKQoK Rm9sbG93IHVwIHRvIGNvbW1pdCA4YTUxMDI3NSwgd2hpY2ggYWRkZWQgdGhlIF9idF9zZXRfc3Rh cnRpa2V5Cm9wdGltaXphdGlvbi4gIF9idF9zZXRfc3RhcnRpa2V5IGlzIG5vdyBmZWF0dXJlIGNv bXBsZXRlOyB0aGVyZSdzIG5vCnJlbWFpbmluZyBraW5kIG9mIG5idHJlZSBzY2FuIGtleSB0aGF0 IGl0IHN0aWxsIGRvZXNuJ3Qgc3VwcG9ydC4KCkF1dGhvcjogUGV0ZXIgR2VvZ2hlZ2FuIDxwZ0Bi b3d0LmllPgpSZXZpZXdlZC1CeTogQ2hhbyBMaSA8bGkuZXZhbi5jaGFvQGdtYWlsLmNvbT4KRGlz Y3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUgyLVd6bkw2WjNIX0dUUXplOWQ4VF9Mcz1j WWJuZC1fOWYtSm83YVlnVEdSVUQ1OGdAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFz dGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0 ZGlmZi83ZDljZDJkZjVmZmMyOTM5YWM4NDU4MWM5NDYzYjhhZmM0Y2E0YzQxCgpNb2RpZmllZCBG aWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHV0aWxzLmMg fCAxNjYgKysrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0KMSBmaWxlIGNoYW5nZWQs IDEzNCBpbnNlcnRpb25zKCspLCAzMiBkZWxldGlvbnMoLSkKCg== --===============7279433801125052231==--