Re: Planner deficiencies with views that use windowing functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Grace <dgrace(at)wingsnw(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Planner deficiencies with views that use windowing functions
Date: 2010-06-29 23:06:16
Message-ID: 26338.1277852776@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Daniel Grace <dgrace(at)wingsnw(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2010-06-30 00:09:59 Re: Keepalives win32
Previous Message Tom Lane 2010-06-29 22:09:29 Re: Cannot cancel the change of a tablespace