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 1rtX48-00FR3W-VT for pgsql-committers@arkaria.postgresql.org; Sun, 07 Apr 2024 18:16:29 +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 1rtX48-00ANo6-2Q for pgsql-committers@arkaria.postgresql.org; Sun, 07 Apr 2024 18:16:28 +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.94.2) (envelope-from ) id 1rtX47-00ANnx-Ry for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 18:16:27 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rtX44-001Qcc-V9 for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 18:16:27 +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 1rtX43-0032tI-1T for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 18:16:23 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rtX42-0010PL-Aw for pgsql-committers@lists.postgresql.org; Sun, 07 Apr 2024 18:16:22 +0000 Content-Type: multipart/mixed; boundary="===============6314494480366504538==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid extra lookups with nbtree array inequalities. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 07 Apr 2024 18:16:22 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6314494480366504538== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgZXh0cmEgbG9va3VwcyB3aXRoIG5idHJlZSBhcnJheSBpbmVxdWFsaXRpZXMuCgpuYnRy ZWUgaW5kZXggc2NhbnMgd2l0aCBTQU9QIGluZXF1YWxpdGllcyAoYnV0IG5vIFNBT1AgZXF1YWxp dGllcykKcGVyZm9ybWVkIGV4dHJhIE9SREVSIHByb2MgbG9va3VwcyBmb3IgYW55IHJlbWFpbmlu ZyBlcXVhbGl0eSBzdHJhdGVneQpzY2FuIGtleXMuICBUaGlzIGNvdWxkIHdhc3RlIGN5Y2xlcywg YW5kIGNhdXNlZCBhc3NlcnRpb24gZmFpbHVyZXMuCktlZXBpbmcgYXJvdW5kIGEgc2VwYXJhdGUg T1JERVIgcHJvYyBpcyBvbmx5IG5lY2Vzc2FyeSBmb3IgYSBzY2FuJ3MKbm9uLWFycmF5L25vbi1T QU9QIGVxdWFsaXR5IHNjYW4ga2V5cyB3aGVuIHRoZSBzY2FuIGhhcyBhdCBsZWFzdCBvbmUKb3Ro ZXIgU0FPUCBlcXVhbGl0eSBzdHJhdGVneSBrZXkgKGEgU0FPUCBpbmVxdWFsaXR5IHNob3VsZG4n dCBjb3VudCkuCgpUbyBmaXgsIHJlcGxhY2UgX2J0X3ByZXByb2Nlc3NfYXJyYXlfa2V5c19maW5h bCdzIGFzc2VydGlvbiB3aXRoIGEgdGVzdAp0aGF0IG1ha2VzIHRoZSBmdW5jdGlvbiByZXR1cm4g ZWFybHkgd2hlbiB0aGUgc2NhbiBoYXMgbm8gU0FPUCBlcXVhbGl0eQpzY2FuIGtleXMuCgpPdmVy c2lnaHQgaW4gY29tbWl0IDFiMTM0Y2E1LCB3aGljaCBlbmhhbmNlZCBuYnRyZWUgU2NhbGFyQXJy YXlPcApleGVjdXRpb24uCgpSZXBvcnRlZC1CeTogQWxleGFuZGVyIExha2hpbiA8ZXhjbHVzaW9u QGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8wNTM5ZDNkMy1hNDAy LTBhNDktZWQ1ZS0yNjQyOWRmZmM0YmRAZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv NDczNDExZmM1MTE1N2U4ZTgyNWVlODY1YzI4MjJmOTc2ZTBkYTVlMwoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9uYnR1dGlscy5jIHwgOCAr KysrKysrLQoxIGZpbGUgY2hhbmdlZCwgNyBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0pCgo= --===============6314494480366504538==--