Re: [HACKERS] would it be a lot of work, to add optimizations accross unions ?

2009-02-28 Thread Gregory Stark
Grzegorz Jaskiewicz g...@pointblue.com.pl writes: Say I have: select foo ( select foo from bar1 union all select foo from bar2 union all select foo from bar3 ... ) a order by foo desc limit X; (and I can give you few other examples around the same 'note', say with when

Re: [HACKERS] would it be a lot of work, to add optimizations accross unions ?

2009-02-28 Thread Grzegorz Jaskiewicz
On 28 Feb 2009, at 11:37, Gregory Stark wrote: Grzegorz Jaskiewicz g...@pointblue.com.pl writes: Say I have: select foo ( select foo from bar1 union all select foo from bar2 union all select foo from bar3 ... ) a order by foo desc limit X; (and I can give you few other examples around

Re: [HACKERS] would it be a lot of work, to add optimizations accross unions ?

2009-02-28 Thread Gregory Stark
Grzegorz Jaskiewicz g...@pointblue.com.pl writes: On 28 Feb 2009, at 11:37, Gregory Stark wrote: I posted a patch to look for an ordered path for members of a union a while back but it still needed a fair amount of work before it was usable. I belive limit it self can't be pushed down, but