| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Limited Sort |
| Date: | 2006-09-18 18:35:07 |
| Message-ID: | 87zmcxt44k.fsf@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Teodor Sigaev <teodor(at)sigaev(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-09-18 18:35:27 | Re: 8.2 beta blockers |
| Previous Message | Rocco Altier | 2006-09-18 18:34:17 | Re: 8.2 beta blockers |