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 1tOJ5O-005U4y-Ch for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2024 16:09:14 +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 1tOJ5N-00Elwr-Dt for pgsql-committers@arkaria.postgresql.org; Thu, 19 Dec 2024 16:09:13 +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 1tOJ5N-00Ellp-2v for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 16:09:12 +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 1tOJ5I-000brN-Se for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 16:09:12 +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-001EYH-5U 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-000NVe-9H for pgsql-committers@lists.postgresql.org; Thu, 19 Dec 2024 16:09:06 +0000 Content-Type: multipart/mixed; boundary="===============0730927853968515968==" 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 --===============0730927853968515968== 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 NWJmNzQ4YjggZmlyc3QgYXBwZWFycy4KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0t LS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8zMWIwYThmMDQw MDQyYzFkZmI5YWMzNTlmZmZiYjZiOGY5Mzc1OTk5CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0t LS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHV0aWxzLmMgfCA4ICsrKysrKy0tCjEg ZmlsZSBjaGFuZ2VkLCA2IGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0pCgo= --===============0730927853968515968==--