Re: Planner deficiencies with views that use windowing functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Planner deficiencies with views that use windowing functions
Date
Msg-id 26338.1277852776@sss.pgh.pa.us
Whole thread Raw
In response to Planner deficiencies with views that use windowing functions  (Daniel Grace <dgrace@wingsnw.com>)
List pgsql-hackers
Daniel Grace <dgrace@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


pgsql-hackers by date:

Previous
From: Daniel Grace
Date:
Subject: Planner deficiencies with views that use windowing functions
Next
From: Bruce Momjian
Date:
Subject: Re: Keepalives win32