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 1syS7G-00019A-QR for pgsql-committers@arkaria.postgresql.org; Wed, 09 Oct 2024 08:32:19 +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 1syRyW-00FfGo-AF for pgsql-committers@arkaria.postgresql.org; Wed, 09 Oct 2024 08:23:16 +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 1syRxw-00FeJS-GC for pgsql-committers@lists.postgresql.org; Wed, 09 Oct 2024 08:22:40 +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 1syRxt-003HQ2-F1 for pgsql-committers@lists.postgresql.org; Wed, 09 Oct 2024 08:22:39 +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=AJVJ36lax1Xhv23JQZeNV6Z/IXUiozeV6iyLgs9POeI=; b=3kjjfDkUgCy5YPIUz52perXYXi Q3JMU3fSHEyGqY9AkXZteYvIVXLGpIpBRnKEUEhF0vgsMvg5C+J5MlH8i1eBUv5/KBh5FvpIBmn25 7R7xpywqAdK+2u6yQcvh6IOOEFw5cjF/Jxh4Y2dZYL4oIFNTLzfOaB6fIh5mezV1haP1LchamVQYO Jelt6XGdjL7048rkMwJ1ELfl9gx5FVucVeATevjYDf7TNlDIiA7avAAuKmK8FWilTvRSOClsku5sa YPjy4zzdk5vFJRBQxEayRI0utPc/QkThgbEkqLnyBNO4YESn5nUz5SOsYUtpcehcN8a2PtKBihnW1 YgHoT78w==; 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 1syRxs-00AFyY-UE for pgsql-committers@lists.postgresql.org; Wed, 09 Oct 2024 08:22:36 +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 1syRxs-0000Tq-P7 for pgsql-committers@lists.postgresql.org; Wed, 09 Oct 2024 08:22:36 +0000 Content-Type: multipart/mixed; boundary="===============2252519808219593952==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Consider explicit incremental sort for mergejoins X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 09 Oct 2024 08:22:36 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2252519808219593952== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Q29uc2lkZXIgZXhwbGljaXQgaW5jcmVtZW50YWwgc29ydCBmb3IgbWVyZ2Vqb2lucwoKRm9yIGEg bWVyZ2Vqb2luLCBpZiB0aGUgZ2l2ZW4gb3V0ZXIgcGF0aCBvciBpbm5lciBwYXRoIGlzIG5vdCBh bHJlYWR5CndlbGwgZW5vdWdoIG9yZGVyZWQsIHdlIG5lZWQgdG8gZG8gYW4gZXhwbGljaXQgc29y dC4gIEN1cnJlbnRseSwgd2UKb25seSBjb25zaWRlciBleHBsaWNpdCBmdWxsIHNvcnQgYW5kIGRv IG5vdCBhY2NvdW50IGZvciBpbmNyZW1lbnRhbApzb3J0LgoKSW4gdGhpcyBwYXRjaCwgZm9yIHRo ZSBvdXRlciBwYXRoIG9mIGEgbWVyZ2Vqb2luLCB3ZSBjaG9vc2UgdG8gdXNlCmV4cGxpY2l0IGlu Y3JlbWVudGFsIHNvcnQgaWYgaXQgaXMgZW5hYmxlZCBhbmQgdGhlcmUgYXJlIHByZXNvcnRlZApr ZXlzLiAgRm9yIHRoZSBpbm5lciBwYXRoLCB0aG91Z2gsIHdlIGNhbm5vdCB1c2UgaW5jcmVtZW50 YWwgc29ydApiZWNhdXNlIGl0IGRvZXMgbm90IHN1cHBvcnQgbWFyay9yZXN0b3JlIGF0IHByZXNl bnQuCgpUaGUgcmF0aW9uYWxlIGlzIGJhc2VkIG9uIHRoZSBhc3N1bXB0aW9uIHRoYXQgaW5jcmVt ZW50YWwgc29ydCBpcwphbHdheXMgZmFzdGVyIHRoYW4gZnVsbCBzb3J0IHdoZW4gdGhlcmUgYXJl IHByZXNvcnRlZCBrZXlzLCBhIHByZW1pc2UKdGhhdCBoYXMgYmVlbiBhcHBsaWVkIGluIHZhcmlv dXMgcGFydHMgb2YgdGhlIGNvZGUuICBJbiBhZGRpdGlvbiwgdGhlCmN1cnJlbnQgY29zdCBtb2Rl bCB0ZW5kcyB0byBmYXZvciBpbmNyZW1lbnRhbCBzb3J0IGFzIGJlaW5nIGNoZWFwZXIKdGhhbiBm dWxsIHNvcnQgaW4gdGhlIHByZXNlbmNlIG9mIHByZXNvcnRlZCBrZXlzLCBtYWtpbmcgaXQgcmVh c29uYWJsZQpub3QgdG8gY29uc2lkZXIgZnVsbCBzb3J0IGluIHN1Y2ggY2FzZXMuCgpJdCBjb3Vs ZCBiZSBhcmd1ZWQgdGhhdCB3aGF0IGlmIGEgbWVyZ2Vqb2luIHdpdGggYW4gaW5jcmVtZW50YWwg c29ydAphcyB0aGUgb3V0ZXIgcGF0aCBpcyBzZWxlY3RlZCBhcyB0aGUgaW5uZXIgcGF0aCBvZiBh bm90aGVyIG1lcmdlam9pbi4KSG93ZXZlciwgdGhpcyBzaG91bGQgbm90IGJlIGEgcHJvYmxlbSwg YmVjYXVzZSBtZXJnZWpvaW4gaXRzZWxmIGRvZXMKbm90IHN1cHBvcnQgbWFyay9yZXN0b3JlIGVp dGhlciwgYW5kIHdlIHdpbGwgYWRkIGEgTWF0ZXJpYWwgbm9kZSBvbgp0b3Agb2YgaXQgYW55d2F5 IGluIHRoaXMgY2FzZSAoc2VlIGZpbmFsX2Nvc3RfbWVyZ2Vqb2luKS4KClRoZXJlIGlzIG9uZSBl bnN1aW5nIHBsYW4gY2hhbmdlIGluIHRoZSByZWdyZXNzaW9uIHRlc3RzLCBhbmQgd2UgaGF2ZQp0 byBtb2RpZnkgdGhhdCB0ZXN0IGNhc2UgdG8gZW5zdXJlIHRoYXQgaXQgY29udGludWVzIHRvIHRl c3Qgd2hhdCBpdAppcyBpbnRlbmRlZCB0by4KCk5vIGJhY2twYXRjaCBhcyB0aGlzIGNvdWxkIHJl c3VsdCBpbiBwbGFuIGNoYW5nZXMuCgpBdXRob3I6IFJpY2hhcmQgR3VvClJldmlld2VkLWJ5OiBE YXZpZCBSb3dsZXksIFRvbWFzIFZvbmRyYQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t L0NBTWJXczQ5eDQyNVFyWDdoPVV4MDVXRW50OEdTNzU3SC1qT1AzX3hzWDV0MUZvVXNad0BtYWls LmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzgyOGU5NGM5ZDJmZDg3YzA2YTc1MzU0 MzYxNTQzMTE5ZDk5MzcwNjgKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNr ZW5kL29wdGltaXplci9wYXRoL2Nvc3RzaXplLmMgICAgICAgICAgfCA2OSArKysrKysrKysrKysr KysrLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9jcmVhdGVwbGFuLmMgICAgICAgIHwg ODkgKysrKysrKysrKysrKysrKysrKysrKystLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9h Z2dyZWdhdGVzLm91dCAgICAgICB8IDM0ICsrKysrLS0tLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBl Y3RlZC9pbmNyZW1lbnRhbF9zb3J0Lm91dCB8IDIxICsrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3Nx bC9hZ2dyZWdhdGVzLnNxbCAgICAgICAgICAgIHwgIDYgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwv aW5jcmVtZW50YWxfc29ydC5zcWwgICAgICB8ICA2ICsrCjYgZmlsZXMgY2hhbmdlZCwgMTg0IGlu c2VydGlvbnMoKyksIDQxIGRlbGV0aW9ucygtKQoK --===============2252519808219593952==--