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 1u0lZ6-007Um7-82 for pgsql-committers@arkaria.postgresql.org; Fri, 04 Apr 2025 18:14:52 +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 1u0lZ4-003G71-7Z for pgsql-committers@arkaria.postgresql.org; Fri, 04 Apr 2025 18:14:50 +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 1u0lZ3-003G6s-R3 for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 18:14:49 +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 1u0lZ1-002xdj-1V for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 18:14:48 +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 1u0lZ0-0009fJ-P1 for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 18:14:46 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u0lZ0-002fvH-12 for pgsql-committers@lists.postgresql.org; Fri, 04 Apr 2025 18:14:46 +0000 Content-Type: multipart/mixed; boundary="===============7105095779714759194==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid extra index searches through preprocessing. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 04 Apr 2025 18:14:46 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7105095779714759194== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgZXh0cmEgaW5kZXggc2VhcmNoZXMgdGhyb3VnaCBwcmVwcm9jZXNzaW5nLgoKVHJhbnNm b3JtIGxvd19jb21wYXJlIGFuZCBoaWdoX2NvbXBhcmUgbmJ0cmVlIHNraXAgYXJyYXkgaW5lcXVh bGl0aWVzCih3aXRoIG9wY2xhc3NlcyB0aGF0IG9mZmVyIHNraXAgc3VwcG9ydCkgaW4gc3VjaCBh IHdheSBhcyB0byBhbGxvdwpfYnRfZmlyc3QgdG8gY29uc2lzdGVudGx5IGFwcGx5IGxhdGVyIGtl eXMgd2hlbiBpdCBkZXNjZW5kcyB0aGUgdHJlZS4KVGhpcyBjYW4gbG93ZXIgdGhlIG51bWJlciBv ZiBpbmRleCBzZWFyY2hlcyBmb3IgbXVsdGktY29sdW1uIHNjYW5zIHRoYXQKdXNlIGEgIj4iIGtl eSBvbiBvbmUgb2YgdGhlIGluZGV4J3MgcHJlZml4IGNvbHVtbnMgKG9yIHVzZSBhICI8IiBrZXks CndoZW4gc2Nhbm5pbmcgYmFja3dhcmRzKSB3aGVuIGl0IHByZWNlZGVzIHNvbWUgbGF0ZXIgbG93 ZXItb3JkZXIga2V5LgoKRm9yIGV4YW1wbGUsIGFuIGluZGV4IHF1YWwgIldIRVJFIGEgPiA1IEFO RCBiID0gMiIgd2lsbCBub3cgYmUgY29udmVydGVkCnRvICJXSEVSRSBhID49IDYgQU5EIGIgPSAy IiBieSBhIG5ldyBwcmVwcm9jZXNzaW5nIHN0ZXAgdGhhdCB0YWtlcyBwbGFjZQphZnRlciBsb3df Y29tcGFyZSBhbmQgaGlnaF9jb21wYXJlIGhhdmUgYmVlbiBmaW5hbGl6ZWQuICBUaGF0IHdheSwg dGhlCmluaXRpYWwgY2FsbCB0byBfYnRfZmlyc3QgY2FuIHVzZSAiV0hFUkUgYSA+PSA2IEFORCBi ID0gMiIgdG8gZmluZCBhbgppbml0aWFsIHBvc2l0aW9uLCByYXRoZXIgdGhhbiBqdXN0IHVzaW5n ICJXSEVSRSBhID4gNSIgLS0gImIgPSAyIiBjYW4gYmUKYXBwbGllZCBkdXJpbmcgZXZlcnkgX2J0 X2ZpcnN0IGNhbGwuICBUaGVyZSdzIGEgZGVjZW50IGNoYW5jZSB0aGF0IHRoaXMKd2lsbCBhbGxv dyBzdWNoIGEgc2NhbiB0byBhdm9pZCB0aGUgZXh0cmEgc2VhcmNoIHRoYXQgbWlnaHQgb3RoZXJ3 aXNlIGJlCm5lZWRlZCB0byBkZXRlcm1pbmUgdGhlIGxvd2VzdCAiYSIgdmFsdWUgc3RpbGwgc2F0 aXNmeWluZyAiV0hFUkUgYSA+IDUiLgoKVGhlIHRyYW5zZm9ybWF0aW9uIHByb2Nlc3MgY2FuIG9u bHkgbG93ZXIgdGhlIHRvdGFsIG51bWJlciBvZiBpbmRleApwYWdlcyByZWFkIHdoZW4gdGhlIHVz ZSBvZiBhIG1vcmUgcmVzdHJpY3RpdmUgc2V0IG9mIGluaXRpYWwgcG9zaXRpb25pbmcKa2V5cyBp biBfYnRfZmlyc3QgYWN0dWFsbHkgYWxsb3dzIHRoZSBzY2FuIHRvIGxhbmQgb24gc29tZSBsYXRl ciBsZWFmCnBhZ2UgZGlyZWN0bHksIHJlbGF0aXZlIHRvIHRoZSB1bm9wdGltaXplZCBjYXNlIChv ciBvbiBhbiBlYXJsaWVyIGxlYWYKcGFnZSBkaXJlY3RseSwgd2hlbiBzY2FubmluZyBiYWNrd2Fy ZHMpLiAgQnV0IHRoZSBzYXZpbmdzIGNhbiByZWFsbHkgYWRkCnVwIGluIGNhc2VzIHdoZXJlIGFu IGFmZmVjdGVkIHNraXAgYXJyYXkgY29tZXMgYWZ0ZXIgc29tZSBvdGhlciBhcnJheS4KRm9yIGV4 YW1wbGUsIGEgc2NhbiBpbmRleHF1YWwgIldIRVJFIHggSU4gKDEsIDIsIDMpIEFORCB5ID4gNSBB TkQgeiA9IDIiCmNhbiBzYXZlIGFzIG1hbnkgYXMgMyBfYnRfZmlyc3QgY2FsbHMgYnkgYXBwbHlp bmcgdGhlIG5ldyB0cmFuc2Zvcm1hdGlvbgp0byBpdHMgInkiIGFycmF5ICh1cCB0byAxIGV4dHJh IHNlYXJjaCBjYW4gYmUgYXZvaWRlZCBwZXIgIngiIGVsZW1lbnQpLgoKRm9sbG93LXVwIHRvIGNv bW1pdCA5MmZlMjNkOSwgd2hpY2ggYWRkZWQgbmJ0cmVlIHNraXAgc2Nhbi4KCkF1dGhvcjogUGV0 ZXIgR2VvZ2hlZ2FuIDxwZ0Bib3d0LmllPgpSZXZpZXdlZC1CeTogTWF0dGhpYXMgdmFuIGRlIE1l ZW50IDxib2VrZXd1cm0rcG9zdGdyZXNAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bv c3Rnci5lcy9tL0NBSDItV3o9Rko3OEszV3NGM2lXTnhXblVDWTlmPUpkZzNRUHhhWEU9dVlVYm11 Uno1UUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2IzZjFhMTNmMjJmOWUy ODg0MmVlNWZiZDA4YjdlYzgwNWUyN2FhYWMKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CnNyYy9iYWNrZW5kL2FjY2Vzcy9uYnRyZWUvbmJ0cHJlcHJvY2Vzc2tleXMuYyB8IDE4MCArKysr KysrKysrKysrKysrKysrKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2NyZWF0ZV9p bmRleC5vdXQgICAgfCAgMjEgKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2NyZWF0ZV9pbmRleC5z cWwgICAgICAgICB8ICAxMCArKwozIGZpbGVzIGNoYW5nZWQsIDIxMSBpbnNlcnRpb25zKCspCgo= --===============7105095779714759194==--