2010/9/26 Pavel Stehule <pavel.steh...@gmail.com>: > Hello, > > there is updated version - with support of window clause. The limits > are work_mem for using inside window aggregate or unlimited when it is > used as standard query. > > This patch needs a few work - can share a compare functionality with > tuplesort.c, but I would to verify a concept now. > > Comments?
Sorry for delay. I read the patch and it seems the result is sane. For window function calls, I agree that the current tuplesort is not enough to implement median functions and the patch introduces its own memsort mechanism, although memsort has too much copied from tuplesort. It looks to me not so difficult to modify the existing tuplesort to guarantee staying in memory always if an option to do so is specified from caller. I think that option can be used by other cases in the core code. Regards, -- Hitoshi Harada -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers