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 1uD59M-006Enl-S7 for pgsql-committers@arkaria.postgresql.org; Thu, 08 May 2025 17:35:13 +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 1uD59L-005FSQ-UK for pgsql-committers@arkaria.postgresql.org; Thu, 08 May 2025 17:35: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 1uCxSm-00288R-3S for pgsql-committers@lists.postgresql.org; Thu, 08 May 2025 09:22:44 +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 1uCxSh-000k0K-2L for pgsql-committers@lists.postgresql.org; Thu, 08 May 2025 09:22:43 +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=9OAsSwV+2nmHXWyLUL2K0W5lk0yIpK/xuI+j6ZO44/M=; b=YD6EIPx15gg2UL3nELCqIXiHUn v4mnuqfh9Z9LpnIBNaPzsu5CISYCAhIFzIcCK9QuLcKItLG1CBxBb0IloixVc0595+/qLUTYakgJo LgznpUpl1lvgy6ZMjILVvHVhIWXfw8DplTo+pWpyeQ0DR2mgrhrlFRP9SW9VZc0lq5gmzhez92JZg vq9gB4UTLUqGQEU9cej4yjD6SCXW4+tHSszTNjdJLor1JGQ9yTcb5OGiRPpoQv/dx2DYobAmEL2eD T/RBf8cvpQv9ruzemtQhZME/HUCrgIB+e9/nVNA3BHoF5Bbn4imwpVbpgK1+6/PN/ckyyjqXa6HoC azAIwgSQ==; 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 1uCxSh-00287b-5X for pgsql-committers@lists.postgresql.org; Thu, 08 May 2025 09:22:39 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uCxSg-000kln-2T for pgsql-committers@lists.postgresql.org; Thu, 08 May 2025 09:22:39 +0000 Content-Type: multipart/mixed; boundary="===============3291643662312009359==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Suppress unnecessary explicit sorting for EPQ mergejoin path X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 08 May 2025 09:22:39 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3291643662312009359== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U3VwcHJlc3MgdW5uZWNlc3NhcnkgZXhwbGljaXQgc29ydGluZyBmb3IgRVBRIG1lcmdlam9pbiBw YXRoCgpXaGVuIGJ1aWxkaW5nIGEgRm9yZWlnblBhdGggZm9yIGEgam9pbnJlbCwgaWYgdGhlcmUn cyBhIHBvc3NpYmlsaXR5CnRoYXQgRXZhbFBsYW5RdWFsIHdpbGwgYmUgZXhlY3V0ZWQsIHdlIG11 c3QgaWRlbnRpZnkgYSBzdWl0YWJsZSBwYXRoCmZvciBFUFEgY2hlY2tzLiAgSWYgdGhlIG91dGVy IG9yIGlubmVyIHBhdGggb2YgdGhlIGNob3NlbiBwYXRoIGlzIGEKRm9yZWlnblBhdGggcmVwcmVz ZW50aW5nIGEgcHVzaGVkLWRvd24gam9pbiwgd2UgcmVwbGFjZSBpdCB3aXRoIGl0cwpmZHdfb3V0 ZXJwYXRoIHRvIGVuc3VyZSB0aGF0IHRoZSBFUFEgY2hlY2sgcGF0aCBjb25zaXN0cyBlbnRpcmVs eSBvZgpsb2NhbCBqb2lucy4KCklmIHRoZSBjaG9zZW4gcGF0aCBpcyBhIE1lcmdlUGF0aCwgYW5k IGl0cyBvdXRlciBvciBpbm5lciBwYXRoIGlzIGEKRm9yZWlnblBhdGggdGhhdCBpcyBub3QgYWxy ZWFkeSB3ZWxsIGVub3VnaCBvcmRlcmVkLCB0aGUgTWVyZ2VQYXRoCndpbGwgaGF2ZSBub24tTklM IG91dGVyc29ydGtleXMgb3IgaW5uZXJzb3J0a2V5cyBpbmRpY2F0aW5nIHRoZQpkZXNpcmVkIG9y ZGVyaW5nIHRvIGJlIGNyZWF0ZWQgYnkgYW4gZXhwbGljaXQgU29ydCBub2RlLiAgSWYgd2UgdGhl bgpyZXBsYWNlIHRoZSBvdXRlciBvciBpbm5lciBwYXRoIHdpdGggaXRzIGNvcnJlc3BvbmRpbmcg ZmR3X291dGVycGF0aCwKYW5kIHRoYXQgcGF0aCBpcyBhbHJlYWR5IHN1ZmZpY2llbnRseSBvcmRl cmVkLCB3ZSBlbmQgdXAgaW4gYW4KaW5jb25zaXN0ZW50IHN0YXRlOiB0aGUgTWVyZ2VQYXRoIGhh cyBub24tTklMIG91dGVyc29ydGtleXMgb3IKaW5uZXJzb3J0a2V5cywgYW5kIGl0cyBpbnB1dCBw YXRoIGlzIGFscmVhZHkgcHJvcGVybHkgb3JkZXJlZC4gIFRoaXMKaW5jb25zaXN0ZW5jeSBjYW4g cmVzdWx0IGluIGFuIEFzc2VydCBmYWlsdXJlIG9yIHRoZSBhZGRpdGlvbiBvZiBhCnJlZHVuZGFu dCBTb3J0IG5vZGUuCgpUbyBmaXgsIGNoZWNrIGlmIHRoZSBuZXcgb3V0ZXIgb3IgaW5uZXIgcGF0 aCBvZiBhIE1lcmdlUGF0aCBpcyBhbHJlYWR5CnByb3Blcmx5IHNvcnRlZCwgYW5kIHNldCBpdHMg b3V0ZXJzb3J0a2V5cyBvciBpbm5lcnNvcnRrZXlzIHRvIE5JTCBpZgpzby4KCkJ1ZzogIzE4OTAy ClJlcG9ydGVkLWJ5OiBOaWtpdGEgS2FsaW5pbiA8bi5rYWxpbmluQHBvc3RncmVzcHJvLnJ1PgpB dXRob3I6IFJpY2hhcmQgR3VvIDxndW9mZW5nbGludXhAZ21haWwuY29tPgpSZXZpZXdlZC1ieTog VGVuZGVyIFdhbmcgPHRuZHJ3YW5nQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS8xODkwMi03MWMxYmVkMmI5ZjdjNDZmQHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0t LS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3Bn L2NvbW1pdGRpZmYvNzczZGIyMjI2OWQ0NzRmYWI0NmQyNWU5ZTE1YjFlNTUyNTJjZjkyYwoKTW9k aWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KY29udHJpYi9wb3N0Z3Jlc19mZHcvZXhwZWN0ZWQv cG9zdGdyZXNfZmR3Lm91dCB8IDY0ICsrKysrKysrKysrKysrKysrKysrKysrKysrCmNvbnRyaWIv cG9zdGdyZXNfZmR3L3NxbC9wb3N0Z3Jlc19mZHcuc3FsICAgICAgfCAgNSArKwpzcmMvYmFja2Vu ZC9mb3JlaWduL2ZvcmVpZ24uYyAgICAgICAgICAgICAgICAgIHwgMzMgKysrKysrKysrKysrKwoz IGZpbGVzIGNoYW5nZWQsIDEwMiBpbnNlcnRpb25zKCspCgo= --===============3291643662312009359==--