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 1u22AA-00BuxM-Sn for pgsql-committers@arkaria.postgresql.org; Tue, 08 Apr 2025 06:10:23 +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 1u22A8-006CaZ-QF for pgsql-committers@arkaria.postgresql.org; Tue, 08 Apr 2025 06:10:21 +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 1u22A8-006CaR-IU for pgsql-committers@lists.postgresql.org; Tue, 08 Apr 2025 06:10:20 +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 1u22A7-003cPe-03 for pgsql-committers@lists.postgresql.org; Tue, 08 Apr 2025 06:10:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=cK04eOQ7ID/AOiomVnIzHlvXJn9lCMtxRTUAnwd9wKI=; b=jTtgh9KfOE7ixSI+KI2JJy7HmE wCVXcn8caRfe0bU6VtqC3Bl0069luzIkde6JL5OKiyHEPRSOPCTip0PibQKrv4fsSNHpG/Dm4uKmi qKFC1HifHmQGsd3h+puW4U6Hwe2zIiZ2RW49Px7GdRm96n+qgFvEs47KIHD19r0VG/73P8iWF2o/9 FRS9LRNFl8021RriBbxc6KE6sfku5QQ39Z3cGLHDVcA1bXyxOe7ZVpC0TmWbRMnK8fFTlQrbPmMfd DKFol+BVyBPQm96F/+XU5MXofZFdfymR4TNHhmv+n1pTEoi5WQTrzsFDlgKqeI8lXw1xxQ4qaq7Eu fAlWKXeg==; 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 1u22A6-001qOr-HF for pgsql-committers@lists.postgresql.org; Tue, 08 Apr 2025 06:10:18 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u22A6-003FKf-0W for pgsql-committers@lists.postgresql.org; Tue, 08 Apr 2025 06:10:18 +0000 Content-Type: multipart/mixed; boundary="===============6319605454202775301==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Speedup child EquivalenceMember lookup in planner X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 08 Apr 2025 06:10:18 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6319605454202775301== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3BlZWR1cCBjaGlsZCBFcXVpdmFsZW5jZU1lbWJlciBsb29rdXAgaW4gcGxhbm5lcgoKV2hlbiBw bGFubmluZyBxdWVyaWVzIHRvIHBhcnRpdGlvbmVkIHRhYmxlcywgd2UgY2xvbmUgYWxsCkVxdWl2 YWxlbmNlTWVtYmVycyBiZWxvbmdpbmcgdG8gdGhlIHBhcnRpdGlvbmVkIHRhYmxlIGludG8gZW1f aXNfY2hpbGQKRXF1aXZhbGVuY2VNZW1iZXJzIGZvciBlYWNoIG5vbi1wcnVuZWQgcGFydGl0aW9u LiAgRm9yIHBhcnRpdGlvbmVkIHRhYmxlcwp3aXRoIGxhcmdlIG51bWJlcnMgb2YgcGFydGl0aW9u cywgdGhpcyBtZWFudCB0aGUgZWNfbWVtYmVycyBsaXN0IGNvdWxkCmJlY29tZSBsYXJnZSBhbmQg Y29kZSBzZWFyY2hpbmcgdGhhdCBsaXN0IHdvdWxkIGJlY29tZSBzbG93LiAgRWZmZWN0aXZlbHks CnRoZSBtb3JlIHBhcnRpdGlvbnMgd2hpY2ggd2VyZSBwcmVzZW50LCB0aGUgbW9yZSBzZWFyY2hl cyBuZWVkZWQgdG8gYmUKcGVyZm9ybWVkIGZvciBvcGVyYXRpb25zIHN1Y2ggYXMgZmluZF9lY19t ZW1iZXJfbWF0Y2hpbmdfZXhwcigpIGR1cmluZwpjcmVhdGVfcGxhbigpIGFuZCB0aGUgbW9yZSBw YXJ0aXRpb25zIHByZXNlbnQsIHRoZSBsb25nZXIgdGhlc2Ugc2VhcmNoZXMKd291bGQgdGFrZSwg aS5lLiwgYSBxdWFkcmF0aWMgc2xvd2Rvd24uCgpUbyBmaXggdGhpcywgaGVyZSB3ZSBhZGp1c3Qg aG93IHdlIHN0b3JlIEVxdWl2YWxlbmNlTWVtYmVycyBmb3IKZW1faXNfY2hpbGQgbWVtYmVycy4g IEluc3RlYWQgb2Ygc3RvcmluZyB0aGVzZSBkaXJlY3RseSBpbiBlY19tZW1iZXJzLAp0aGVzZSBh cmUgbm93IHN0b3JlZCBpbiBhIG5ldyBhcnJheSBvZiBMaXN0cyBpbiB0aGUgRXF1aXZhbGVuY2VD bGFzcywKd2hpY2ggaXMgaW5kZXhlZCBieSB0aGUgcmVsaWQuICBXaGVuIHdlIHdhbnQgdG8gZmlu ZCBFcXVpdmFsZW5jZU1lbWJlcnMKYmVsb25naW5nIHRvIGEgY2VydGFpbiBjaGlsZCByZWxhdGlv biwgd2UgY2FuIG5hcnJvdyB0aGUgc2VhcmNoIHRvIHRoZQphcnJheSBlbGVtZW50IGZvciB0aGF0 IHJlbGF0aW9uLgoKVG8gbWFrZSBFcXVpdmFsZW5jZU1lbWJlciBsb29rdXAgZWFzaWVyIGFuZCB0 byByZWR1Y2UgdGhlIGFtb3VudCBvZiBjb2RlCmNoYW5nZSwgdGhpcyBjb21taXQgcHJvdmlkZXMg YSBwYWlyIG9mIGZ1bmN0aW9ucyB0byBhbGxvdyBpdGVyYXRpb24gb3Zlcgp0aGUgRXF1aXZhbGVu Y2VNZW1iZXJzIG9mIGFuIEVDIHdoaWNoIGFsc28gaGFuZGxlcyBmaW5kaW5nIHRoZSBjaGlsZApt ZW1iZXJzLCBpZiByZXF1aXJlZC4gIENhbGxlcnMgdGhhdCBuZXZlciBuZWVkIHRvIGxvb2sgYXQg Y2hpbGQgbWVtYmVycwpjYW4gcmVtYWluIHVzaW5nIHRoZSBmb3JlYWNoIGxvb3Agb3ZlciBlY19t ZW1iZXJzLCB3aGljaCB3aWxsIG5vdyBvZnRlbgpiZSBmYXN0ZXIgZHVlIHRvIG9ubHkgcGFyZW50 LWxldmVsIG1lbWJlcnMgYmVpbmcgc3RvcmVkIHRoZXJlLgoKVGhlIGFjdHVhbCBwZXJmb3JtYW5j ZSBpbmNyZWFzZXMgaGVyZSBhcmUgaGlnaGx5IGRlcGVuZGVudCBvbiB0aGUgbnVtYmVyCm9mIHBh cnRpdGlvbnMgYW5kIHRoZSBxdWVyeSBiZWluZyBwbGFubmVkLiAgUGVyZm9ybWFuY2UgaW5jcmVh c2VzIGNhbiBiZQp2aXNpYmxlIHdpdGggYXMgZmV3IGFzIDggcGFydGl0aW9ucywgYnV0IHRoZSBz cGVlZHVwIGlzIG1hcmdpbmFsIGZvcgpzdWNoIGxvdyBudW1iZXJzIG9mIHBhcnRpdGlvbnMuICBU aGUgc3BlZWR1cHMgYmVjb21lIG11Y2ggbW9yZSB2aXNpYmxlCndpdGggYSBmZXcgZG96ZW4gdG8g aHVuZHJlZHMgb2YgcGFydGl0aW9ucy4gIFdpdGggc29tZSB0ZXN0ZWQgcXVlcmllcwp1c2luZyA1 NiBwYXJ0aXRpb25zLCB0aGUgcGxhbm5lciB3YXMgYXJvdW5kIDN4IGZhc3RlciB0aGFuIGJlZm9y ZS4gIEZvcgp1c2UgY2FzZXMgd2l0aCB0aG91c2FuZHMgb2YgcGFydGl0aW9ucywgdGhlc2UgYXJl IGxpa2VseSB0byBiZWNvbWUKc2lnbmlmaWNhbnRseSBmYXN0ZXIuICBTb21lIHRlc3RpbmcgaGFz IHNob3duIHBsYW5uZXIgc3BlZWR1cHMgb2YgNjB4IG9yCm1vcmUgd2l0aCA4MTkyIHBhcnRpdGlv bnMuCgpBdXRob3I6IFl1eWEgV2F0YXJpIDx3YXRhcmkueXV5YUBnbWFpbC5jb20+CkNvLWF1dGhv cmVkLWJ5OiBEYXZpZCBSb3dsZXkgPGRncm93bGV5bWxAZ21haWwuY29tPgpSZXZpZXdlZC1ieTog RGF2aWQgUm93bGV5IDxkZ3Jvd2xleW1sQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFRvbSBMYW5l IDx0Z2xAc3NzLnBnaC5wYS51cz4KUmV2aWV3ZWQtYnk6IEFuZHJleSBMZXBpa2hvdiA8YS5sZXBp a2hvdkBwb3N0Z3Jlc3Byby5ydT4KUmV2aWV3ZWQtYnk6IEFsZW5hIFJ5YmFraW5hIDxsZW5hLnJp YmFja2luYUB5YW5kZXgucnU+ClJldmlld2VkLWJ5OiBEbWl0cnkgRG9sZ292IDw5ZXJ0aGFsaW9u NkBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBBbWl0IExhbmdvdGUgPGFtaXRsYW5nb3RlMDlAZ21h aWwuY29tPgpSZXZpZXdlZC1ieTogQXNodXRvc2ggQmFwYXQgPGFzaHV0b3NoLmJhcGF0Lm9zc0Bn bWFpbC5jb20+ClRlc3RlZC1ieTogVGhvbSBCcm93biA8dGhvbUBsaW51eC5jb20+ClRlc3RlZC1i eTogbmV3dGdsb2JhbCBwb3N0Z3Jlc3FsX2NvbnRyaWJ1dG9ycyA8cG9zdGdyZXNxbF9jb250cmli dXRvcnNAbmV3dGdsb2JhbGNvcnAuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t L0NBSjJwTWtaTkNnb1VLU0UlMkJfNUx0aEQlMkJLYlhLdnE2aDJoUU44RXN4cHhkJTJCY3htZ29t ZyU0MG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0t Cmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZDY5ZDQ1YTVhOTU2ZTkz MGRjOTFiM2NhMDlhMDE4OGJmOWZlMjE3NgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0K Y29udHJpYi9wb3N0Z3Jlc19mZHcvcG9zdGdyZXNfZmR3LmMgICAgICAgfCAgMTkgKy0Kc3JjL2Jh Y2tlbmQvbm9kZXMvb3V0ZnVuY3MuYyAgICAgICAgICAgICAgfCAgIDIgKwpzcmMvYmFja2VuZC9v cHRpbWl6ZXIvcGF0aC9lcXVpdmNsYXNzLmMgICB8IDQxMCArKysrKysrKysrKysrKysrKysrKysr LS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvaW5keHBhdGguYyAgICAgfCAgIDgg Ky0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvcGF0aGtleXMuYyAgICAgfCAgMTAgKy0Kc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vYW5hbHl6ZWpvaW5zLmMgfCAgMTQgKwpzcmMvaW5jbHVk ZS9ub2Rlcy9wYXRobm9kZXMuaCAgICAgICAgICAgICB8ICA5OCArKysrKystCnNyYy9pbmNsdWRl L29wdGltaXplci9wYXRocy5oICAgICAgICAgICAgIHwgICA0ICsKc3JjL3Rvb2xzL3BnaW5kZW50 L3R5cGVkZWZzLmxpc3QgICAgICAgICAgfCAgIDEgKwo5IGZpbGVzIGNoYW5nZWQsIDQ0NiBpbnNl cnRpb25zKCspLCAxMjAgZGVsZXRpb25zKC0pCgo= --===============6319605454202775301==--