Re: [HACKERS] Limited Sort

2006-09-18 Thread Gregory Stark
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

Re: [HACKERS] Limited Sort

2006-09-18 Thread Teodor Sigaev
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. -- Teodor Sigaev E-mai

Re: [HACKERS] Limited Sort

2006-09-18 Thread Simon Riggs
On Mon, 2006-09-18 at 14:26 +0100, Gregory Stark wrote: > And lastly I find the idea of putting attention into OLAP functionality > interesting. Does anyone have any ideas on where to start with that? In SQL:2003 the OLAP functionality mostly relies on the concept of sorted Windows over which "Wi