[HACKERS] Re: Window function optimisation, allow pushdowns of items matching PARTITION BY clauses

2014-04-14 Thread David Rowley
On 14 April 2014 02:50, Thomas Mayer wrote: > Hello David, > > thanks for your work. The results look promising. > Thanks > > What I'm missing is a test case with multiple fields in the partition by > clauses: > > I've modified the patch and added some regression tests that I think cover all o

[HACKERS] Re: Window function optimisation, allow pushdowns of items matching PARTITION BY clauses

2014-04-13 Thread Thomas Mayer
Hello David, thanks for your work. The results look promising. What I'm missing is a test case with multiple fields in the partition by clauses: -- should push down, because partid is part of all PARTITION BY clauses explain analyze select partid,n,m from ( select partid, count(*) over (p