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
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