On Tue, Mar 23, 2010 at 8:23 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The real question is what benefit you expect to get. If the filter
> condition can't be pushed below the window functions (which AFAICS
Even on the partition key?
Right now if you define a view with a windowing + PARTITION BY clause
in it and people write a lot of queries to interrogate one partition
or the other, you end up computing results for the entire relation,
and then filtering all but one partition out, in my understanding.
Since it seems on the surface there is no context sensitivity(?)
between partitions in this kind of a case it would seem a qual
pushdown on the partition key would help rather intensely.
fdr
