Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooMHl-0003Kf-9Y for pgsql-committers@arkaria.postgresql.org; Fri, 28 Oct 2022 10:08:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ooMHk-0004xd-59 for pgsql-committers@arkaria.postgresql.org; Fri, 28 Oct 2022 10:08:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooMHj-0004xU-Ou for pgsql-committers@lists.postgresql.org; Fri, 28 Oct 2022 10:08:19 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooMHh-0003W8-4S for pgsql-committers@lists.postgresql.org; Fri, 28 Oct 2022 10:08:18 +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=ckro8h0RiJvoGWlHA0rDPHGBOhghHUuZc9zjTlwAc3I=; b=B9FiQQdfzi4a0WQ90mICfRNuSn tE4tBPHwty0LQfr0xApBRQ0U9kTaaWQ600cWPUAG9faq5HrCvVo7DajnKUPp14FGdt7dDFl3SU36g fJ3qn1H0GdAu/P5JhRk3wHGgoLp+KOzv2+oSFIRJRRu4bGsm6WdsOgj63acwyoJw0ygrhPqbPHyJL 5EC9LlGQU+u+ldOgSHRDu7GQxxbS4JTeNZ/mrYkWNMQ1G8VtznIQTAxe31YSKLQk4AKmFEYhkK1ww pW4QCWgiAwLctpvAqRL9s/2YqJa3ScmRAXACR8gp4ieqal49QuG3iYGKM6ntiWyUP+YMhiODPMTyo tcii5EkQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooMHg-00053y-Pz for pgsql-committers@lists.postgresql.org; Fri, 28 Oct 2022 10:08:16 +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 1ooMHf-0019kV-QX for pgsql-committers@lists.postgresql.org; Fri, 28 Oct 2022 10:08:16 +0000 Content-Type: multipart/mixed; boundary="===============5235017366917377947==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Use Limit instead of Unique to implement DISTINCT, when possible X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 28 Oct 2022 10:08:16 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5235017366917377947== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIExpbWl0IGluc3RlYWQgb2YgVW5pcXVlIHRvIGltcGxlbWVudCBESVNUSU5DVCwgd2hlbiBw b3NzaWJsZQoKV2hlbiBhbGwgb2YgdGhlIHF1ZXJ5J3MgRElTVElOQ1QgcGF0aGtleXMgaGF2ZSBi ZWVuIG1hcmtlZCBhcyByZWR1bmRhbnQKZHVlIHRvIEVxdWl2YWxlbmNlQ2xhc3NlcyBleGlzdGlu ZyB3aGljaCBjb250YWluIGNvbnN0YW50cywgd2UgY2FuIGp1c3QKaW1wbGVtZW50IHRoZSBESVNU SU5DVCBvcGVyYXRpb24gb24gYSBxdWVyeSBieSBqdXN0IGxpbWl0aW5nIHRoZSBudW1iZXIgb2YK cmV0dXJuZWQgcm93cyB0byAxIGluc3RlYWQgb2YgcGVyZm9ybWluZyBhIFVuaXF1ZSBvbiBhbGwg b2YgdGhlIG1hdGNoaW5nCihkdXBsaWNhdGUpIHJvd3MuCgpUaGlzIGFwcGxpZXMgaW4gY2FzZXMg c3VjaCBhczoKClNFTEVDVCBESVNUSU5DVCBjb2wsY29sMiBGUk9NIHRhYiBXSEVSRSBjb2wgPSAx IEFORCBjb2wyID0gMTA7CgpJZiB0aGVyZSBhcmUgYW55IG1hdGNoaW5nIHJvd3MsIHRoZW4gdGhl eSBtdXN0IGFsbCBiZSB7MSwxMH0uICBUaGVyZSdzIG5vCnBvaW50IGluIGZldGNoaW5nIGFsbCBv ZiB0aG9zZSBhbmQgcnVubmluZyBhIFVuaXF1ZSBvcGVyYXRvciBvbiB0aGVtIHRvCmxlYXZlIG9u bHkgYSBzaW5nbGUgcm93LiAgSGVyZSB3ZSBlZmZlY3RpdmVseSBqdXN0IGZpbmQgdGhlIGZpcnN0 IHJvdyBhbmQKdGhlbiBzdG9wLiAgV2UgYXJlIG9idmlvdXNseSB1bmFibGUgdG8gYXBwbHkgdGhp cyBvcHRpbWl6YXRpb24gaWYgZWl0aGVyCnRoZSBjb2wgPSAxIG9yIGNvbDIgPSAxMCB3ZXJlIG1p c3NpbmcgZnJvbSB0aGUgV0hFUkUgY2xhdXNlIG9yIGlmIHRoZXJlCndlcmUgYW55IGFkZGl0aW9u YWwgY29sdW1ucyBpbiB0aGUgU0VMRUNUIGNsYXVzZS4KClN1Y2ggcXVlcmllcyBhcmUgcHJvYmFi bHkgbm90IGFsbCB0aGF0IGNvbW1vbiwgYnV0IGRldGVjdGluZyB3aGVuIHdlIGNhbgphcHBseSB0 aGlzIG9wdGltaXphdGlvbiBhbW91bnRzIHRvIGNoZWNraW5nIGlmIHRoZSBkaXN0aW5jdF9wYXRo a2V5cyBhcmUKTlVMTCwgd2hpY2ggaXMgdmVyeSBjaGVhcCBpbmRlZWQuCgpOb3RoaW5nIGlzIGRv bmUgaGVyZSB0byBjaGVjayBpZiB0aGUgcXVlcnkgYWxyZWFkeSBoYXMgYSBMSU1JVCBjbGF1c2Uu ICBJZgppdCBkb2VzIHRoZW4gdGhlIHBsYW4gbWF5IGVuZCB1cCB3aXRoIDIgTGltaXRzIG5vZGVz LiAgVGhlcmUncyBubyBoYXJtIGluCnRoYXQgYW5kIGl0J3MgcHJvYmFibHkgbm90IHdvcnRoIHRo ZSBjb21wbGV4aXR5IHRvIHVuaWZ5IHRoZW0gaW50byBhCnNpbmdsZSBMaW1pdCBub2RlLgoKQXV0 aG9yOiBEYXZpZCBSb3dsZXkKUmV2aWV3ZWQtYnk6IFJpY2hhcmQgR3VvCkRpc2N1c3Npb246IGh0 dHBzOi8vcG9zdGdyLmVzL20vQ0FBcEhEdnFTMGo4UlVXUlVTZ0NBWHhPcW5ZakhVWG1Ld3NwUmo0 R3pWZk9PMjVCeUhBQG1haWwuZ21haWwuY29tCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVz L20vTUVZUFIwMU1CNzEwMUNENURBMEEwN0M5REUyQjc0ODUwQTQyMzlATUVZUFIwMU1CNzEwMS5h dXNwcmQwMS5wcm9kLm91dGxvb2suY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwot LS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNTU0MzY3N2Vj OTBhMTVjNzNkYWI1ZWQ0ZjA5MDJiM2I5MjBmMGI4NwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0t LS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICAgICAgICAgIHwg NzcgKysrKysrKysrKysrKysrKysrKystLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc2Vs ZWN0X2Rpc3RpbmN0Lm91dCAgICB8IDU0ICsrKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jl c3MvZXhwZWN0ZWQvc2VsZWN0X2Rpc3RpbmN0X29uLm91dCB8IDUwICsrKysrKysrKysrKysrKwpz cmMvdGVzdC9yZWdyZXNzL3NxbC9zZWxlY3RfZGlzdGluY3Quc3FsICAgICAgICAgfCAyNiArKysr KysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9zZWxlY3RfZGlzdGluY3Rfb24uc3FsICAgICAgfCAy NSArKysrKysrKwo1IGZpbGVzIGNoYW5nZWQsIDIyMSBpbnNlcnRpb25zKCspLCAxMSBkZWxldGlv bnMoLSkKCg== --===============5235017366917377947==--