Teodor Sigaev <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
