[GENERAL] Window Function API Performance

2011-09-13 Thread Schneider, Thilo
Dear all, first let me thank the PostgreSQL developers for implementing the incredibly helpful window functions. This is one of the features I use most often. But, as my requirements are perhaps a bit special, I always want more ;) Now I am trying to implement my own window function using

Re: [GENERAL] Window Function API Performance

2011-09-13 Thread Tom Lane
Schneider, Thilo t.schneid...@fraport.de writes: Currently I access rows of the window partition using the WinGetFuncArgInPartition function. However, what I noticed is that this function seems incredibly slow when the partition looked at is rather large - for my case about 1245000 rows. It