Teodor Sigaev <teodor@sigaev.ru> writes:
> When we was talking about optimizing 'ORDER BY .. LIMIT' with Oleg and Alvaro
> at conference, we was thinking to make new executor's node - Partial Sort. And
> planner may choose which nodes to use: nodeSort and nodeLimit or
> nodePartialSort.
That's an interesting option too. Certainly it preserves the kind of
separation between nodes that we have currently. It also might make costing
the plan more practical.
The downside would be that we would start having a proliferation of nodes.
Several node types can take advantage of a limit.
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com