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 1pFM9E-0000rd-53 for pgsql-committers@arkaria.postgresql.org; Tue, 10 Jan 2023 21:27:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pFM9C-0001OP-71 for pgsql-committers@arkaria.postgresql.org; Tue, 10 Jan 2023 21:27:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFM9B-0001OF-Q3 for pgsql-committers@lists.postgresql.org; Tue, 10 Jan 2023 21:27:05 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFM94-0004QN-A8 for pgsql-committers@lists.postgresql.org; Tue, 10 Jan 2023 21:27:05 +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=ld0JeZkxZKwPPC5jOUaAayyhgOTeK6N64XQCQP1DTmg=; b=WO+M9Z97GGeeBvhTuQJ9Bp2xlu KHWr8KlgbZHpECRksU5t8tahrnjeByvcB2+2bJ7T3Al9gHjcAw5ABEMS21pxUfNI7zJ5ORygUcFzk sBdlyYJzsgXWtJi39WMvOXUjW4J+HN+ri1idi/L+ogfMH5Fi/NV2Day+w394/acixB50Ga716rHRh eAWbWJGNI6iiQST4xsGiWAw+PoBFsFSENoBeuy9gdDH+0q0LpgXOWzbryZ22RjMsHUynlWKkEeRWL bKVFyXb6FQgrRxEVDxsjNGLEzO/YVXx724XspiUl0lRlBfmW6axcRJzRqz1HsingHiE4SZS+vEbiw J8WNMEJg==; 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 1pFM92-0008R4-UM for pgsql-committers@lists.postgresql.org; Tue, 10 Jan 2023 21:26:56 +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 1pFM91-0031tf-FN for pgsql-committers@lists.postgresql.org; Tue, 10 Jan 2023 21:26:55 +0000 Content-Type: multipart/mixed; boundary="===============8512096644049444159==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Have the planner consider Incremental Sort for DISTINCT X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 10 Jan 2023 21:26:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8512096644049444159== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGF2ZSB0aGUgcGxhbm5lciBjb25zaWRlciBJbmNyZW1lbnRhbCBTb3J0IGZvciBESVNUSU5DVAoK UHJpb3IgdG8gdGhpcywgd2Ugb25seSBjb25zaWRlcmVkIGEgZnVsbCBzb3J0IG9uIHRoZSBjaGVh cGVzdCBpbnB1dCBwYXRoCmFuZCB1bmlxdWlmeWluZyBhbnkgcGF0aCB3aGljaCB3YXMgYWxyZWFk eSBzb3J0ZWQgaW4gdGhlIHJlcXVpcmVkIHNvcnQKb3JkZXIuICBIZXJlIHdlIGFkanVzdCBjcmVh dGVfZmluYWxfZGlzdGluY3RfcGF0aHMoKSBzbyB0aGF0IGl0IGFsc28KYWRkcyBhbiBJbmNyZW1l bnRhbCBTb3J0IHBhdGggb24gYW55IHBhdGggd2hpY2ggaGFzIHByZXNvcnRlZCBrZXlzLgoKQWRk aXRpb25hbGx5LCB0aGlzIGFkanVzdHMgdGhlIHBhcmFsbGVsIGRpc3RpbmN0IGNvZGUgc28gdGhh dCB3ZSBub3cKY29uc2lkZXIgc29ydGluZyB0aGUgY2hlYXBlc3QgcGFydGlhbCBwYXRoIGFuZCBp bmNyZW1lbnRhbGx5IHNvcnRpbmcgYW55CnBhcnRpYWwgcGF0aHMgd2l0aCBwcmVzb3J0ZWQga2V5 cy4gIFByZXZpb3VzbHkgd2UgZGlkbid0IGNvbnNpZGVyIGFueQpzb3J0aW5nIGZvciBwYXJhbGxl bCBkaXN0aW5jdCBhbmQgb25seSBhZGRlZCBhIHVuaXF1ZSBwYXRoIGF0b3AgYW55IHBhdGgKd2hp Y2ggaGFkIHRoZSByZXF1aXJlZCBwYXRoa2V5cyBhbHJlYWR5LgoKQXV0aG9yOiBEYXZpZCBSb3ds ZXkKUmV2aWV3ZWQtYnk6IFJpY2hhcmQgR3VvCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVz L20vQ0FBcEhEdm84THoySD00MnVyQmJmUDY1TFRjRVVPaDI4OE1UN0RzRzJfRVd0VzFBWEhRQG1h aWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBz Oi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvM2M2ZmM1ODIwOWYyNGI5NTllZTE4 ZjVkMTllZjk2NDAzZDA4ZjE1YwoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2Jh Y2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgICAgICAgICB8IDIyMiArKysrKysrKysr KysrKy0tLS0tLS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaW5jcmVtZW50YWxfc29y dC5vdXQgfCAgMTMgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zZWxlY3RfZGlzdGluY3Qu b3V0ICB8ICAzMSArKystCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvd2luZG93Lm91dCAgICAg ICAgICAgfCAgMTAgKy0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvc2VsZWN0X2Rpc3RpbmN0LnNxbCAg ICAgICB8ICAgOCArCjUgZmlsZXMgY2hhbmdlZCwgMTczIGluc2VydGlvbnMoKyksIDExMSBkZWxl dGlvbnMoLSkKCg== --===============8512096644049444159==--