Re: [HACKERS] Planner deficiencies with views that use windowing functions

2010-06-29 Thread Tom Lane
Daniel Grace 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 h

[HACKERS] Planner deficiencies with views that use windowing functions

2010-06-29 Thread Daniel Grace
I found some interesting discrepancies with the query planner when working with views (and presumably table subqueries) that contain windowing functions.  This is all tested on 9.0beta2, though I suspect 8.4 has the same limitations. The short version is: - If querying a windowing view and asking