From: Tom Lane on
Daniel Grace <dgrace(a)wingsnw.com> writes:
> I found some interesting discrepancies with the query planner when
> working with views (and presumably table subqueries) that contain
> windowing functions.

Yeah, there's next to no optimization for window functions ATM.
This will probably get better over time, but don't hold your breath ...

regards, tom lane

--
Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers