Re: Why does create_gather_merge_plan need make_sort? - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: Why does create_gather_merge_plan need make_sort?
Date
Msg-id b86de02e-4dc3-5aa9-704b-45f47937cd64@enterprisedb.com
Whole thread Raw
In response to Why does create_gather_merge_plan need make_sort?  (James Coleman <jtc331@gmail.com>)
Responses Re: Why does create_gather_merge_plan need make_sort?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 11/20/20 11:24 PM, James Coleman wrote:
> While looking at another issue I noticed that create_gather_merge_plan
> calls make_sort if the subplan isn't sufficiently sorted. In all of
> the cases I've seen where a gather merge path (not plan) is created
> the input path is expected to be properly sorted, so I was wondering
> if anyone happened to know what case is being handled by the make_sort
> call. Removing it doesn't seem to break any tests.
> 

Yeah, I think you're right this is dead code, essentially. We're only
ever calling create_gather_merge_path() with pathkeys matching the
subpath. And it's like that on REL_12_STABLE too, i.e. before the
incremental sort was introduced.


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [bug+patch] Inserting DEFAULT into generated columns from VALUES RTE
Next
From: Tom Lane
Date:
Subject: Re: Why does create_gather_merge_plan need make_sort?