> I'm also not sure how to handle this if the set has to be spooled to > disk. Quicksort and Quickselect do a lot of scans throught he data and > wouldn't perform well on disk.
I thing, so problem is in aggregate func used as window func - or some missing optimalisation. when I replaced count(*) over () by subselect (SELECT count(*) FROM ...) then I got expected speed. Pavel > > -- > greg > http://mit.edu/~gsstark/resume.pdf > -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers