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 1tOJ5M-005U4h-LA for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2024 16:09:12 +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 1tOJ5L-00Elak-Mq for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2024 16:09:11 +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 1tOJ5L-00Elaa-Fj for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 16:09:11 +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.94.2) (envelope-from ) id 1tOJ5I-000P9b-7H for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 16:09: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 1tOJ5H-001EYI-5Z for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 16:09:07 +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 1tOJ5G-000NVf-9h for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 16:09:06 +0000 Content-Type: multipart/mixed; boundary="===============0150120128198310275==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid nbtree index scan SAOP scanBehind confusion. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 19 Dec 2024 16:09:06 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0150120128198310275== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgbmJ0cmVlIGluZGV4IHNjYW4gU0FPUCBzY2FuQmVoaW5kIGNvbmZ1c2lvbi4KCkNvbnNp c3RlbnRseSByZXNldCBzby0+c2NhbkJlaGluZCBhdCB0aGUgYmVnaW5uaW5nIG9mIG5idHJlZSBh cnJheQphZHZhbmNlbWVudCwgZXZlbiBkdXJpbmcgc2t0cmlnX3JlcXVpcmVkPWZhbHNlIGNhbGxz IChjYWxscyB3aGVyZSBhcnJheQphZHZhbmNlbWVudCBpcyB0cmlnZ2VyZWQgYnkgYW4gdW5zYXRp c2ZpZWQgbm9uLXJlcXVpcmVkIGFycmF5IHNjYW4ga2V5KS4KT3RoZXJ3aXNlLCBpdCdzIHBvc3Np YmxlIGZvciBxdWVyaWVzIHRvIGZhaWwgdG8gcmV0dXJuIGFsbCByZWxldmFudAp0dXBsZXMgdG8g dGhlIHNjYW4gZ2l2ZW4gYSBsb3ctb3JkZXIgcmVxdWlyZWQgc2NhbiBrZXkgdGhhdCB3YXMKcHJl dmlvdXNseSBkZWVtZWQgInNhdGlzZmllZCIgYnkgYSB0cnVuY2F0ZWQgaGlnaCBrZXkgYXR0cmli dXRlIHZhbHVlLgpUaGlzIG9ubHkgaGFwcGVuZWQgYXQgdGhlIHBvaW50IHdoZXJlIGEgbGF0ZXIg bm9uLXJlcXVpcmVkIGFycmF5IHNjYW4Ka2V5IG5lZWRlZCB0byBiZSAiYWR2YW5jZWQiIG9uY2Ug b24gdGhlIG5leHQgbGVhZiBwYWdlICh0aGF0IGlzLCBvbmNlCnRoZSByaWdodCBzaWJsaW5nIG9m IHRoZSB0cnVuY2F0ZWQgaGlnaCBrZXkgcGFnZSB3YXMgcmVhY2hlZCkuCgpUaGUgdW5kZXJseWlu ZyBpc3N1ZSB3YXMgdGhhdCBsYXRlciBjb2RlIHdpdGhpbiBfYnRfYWR2YW5jZV9hcnJheV9rZXlz CmFzc3VtZWQgdGhhdCB0aGUgc28tPnNjYW5CZWhpbmQgZmxhZyBtdXN0IGhhdmUgYmVlbiBzZXQg dXNpbmcgdGhlCmN1cnJlbnQgcGFnZSdzIGhpZ2gga2V5IChub3QgdGhlIHByZXZpb3VzIHBhZ2Un cyBoaWdoIGtleSkuICBBbnkgbGF0ZXIKc3VjY2Vzc2Z1bCByZWNoZWNrIGNhbGwgdG8gX2J0X2No ZWNrX2NvbXBhcmUgd291bGQgdGhlcmVmb3JlIHNwdXJpb3VzbHkKYmUgcHJldmVudGVkIGZyb20g bWFraW5nIF9idF9hZHZhbmNlX2FycmF5X2tleXMgcmV0dXJuIHRydWUsIGJhc2VkIG9uCnRoZSBm YXVsdHkgYmVsaWVmIHRoYXQgdGhlIHRydW5jYXRlZCBhdHRyaWJ1dGUgbXVzdCBiZSBmcm9tIHRo ZSBzY2FuJ3MKY3VycmVudCB0dXBsZSAoaS5lLiB0aGUgbm9uLXBpdm90IHR1cGxlIGF0IHRoZSBz dGFydCBvZiB0aGUgbmV4dCBwYWdlKS4KX2J0X2FkdmFuY2VfYXJyYXlfa2V5cyB3b3VsZCByZXR1 cm4gZmFsc2UgZm9yIHRoZSB0dXBsZSwgdWx0aW1hdGVseQpyZXN1bHRpbmcgaW4gX2J0X2NoZWNr a2V5cyBmYWlsaW5nIHRvIHJldHVybiBhIG1hdGNoaW5nIHR1cGxlLgoKT3ZlcnNpZ2h0IGluIGNv bW1pdCA1YmY3NDhiOCwgd2hpY2ggZW5oYW5jZWQgbmJ0cmVlIFNjYWxhckFycmF5T3AKZXhlY3V0 aW9uLgoKQXV0aG9yOiBQZXRlciBHZW9naGVnYW4gPHBnQGJvd3QuaWU+CkRpc2N1c3Npb246IGh0 dHBzOi8vcG9zdGdyLmVzL20vQ0FIMi1XemtKS25jZnF5QVVUZXVCNUdnUmhUMXZoc1dPMnExMWRi Wk5xS212am9wUF9nQG1haWwuZ21haWwuY29tCkJhY2twYXRjaDogMTctLCB3aGVyZSBjb21taXQg NWJmNzQ4YjggZmlyc3QgYXBwZWFycy4KCkJyYW5jaAotLS0tLS0KUkVMXzE3X1NUQUJMRQoKRGV0 YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvOWU4 NWIyMGRhN2NkODllYjBmYzUwM2Q0ZGQ0OGY1ZmM4NmI0NWY2NAoKTW9kaWZpZWQgRmlsZXMKLS0t LS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9uYnR1dGlscy5jIHwgOCArKysr KystLQoxIGZpbGUgY2hhbmdlZCwgNiBpbnNlcnRpb25zKCspLCAyIGRlbGV0aW9ucygtKQoK --===============0150120128198310275==--