Re: MergeAppend could consider sorting cheapest child path - Mailing list pgsql-hackers

From Andy Fan
Subject Re: MergeAppend could consider sorting cheapest child path
Date
Msg-id 87wmi7tvo7.fsf@163.com
Whole thread Raw
In response to Re: MergeAppend could consider sorting cheapest child path  (Bruce Momjian <bruce@momjian.us>)
Responses Re: MergeAppend could consider sorting cheapest child path
Re: MergeAppend could consider sorting cheapest child path
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:

> Is this still being considered?

I'd +1 on this feature. I guess this would be more useful on parallel
case, where the Sort can be pushed down to parallel worker, and in the
distributed database case, where the Sort can be pushed down to multiple
nodes, at the result, the leader just do the merge works.

At the high level implementaion, sorting *cheapest* child path looks
doesn't add too much overhead on the planning effort. 

-- 
Best Regards
Andy Fan




pgsql-hackers by date:

Previous
From: Shinya Kato
Date:
Subject: Re: Set AUTOCOMMIT to on in script output by pg_dump
Next
From: Bruce Momjian
Date:
Subject: Re: Should we document how column DEFAULT expressions work?