Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group