Volker Grabsch <vog(at)notjusthosting(dot)com> writes:
> I propose the following general optimization: If all window
> functions are partitioned by the same first field (here: id),
> then any filter on that field should be executed before
> WindowAgg.

I'm not sure if that rule is correct in detail, but in any case the
short answer is that window aggregates are a new feature in Postgres
and we basically haven't done any optimization work on them yet.
Feel free to work in that area if it interests you...

			regards, tom lane

In response to

• Missing optimization when filters are applied after window functions at 2012-05-16 07:50:17 from Volker Grabsch

Responses

• Re: Missing optimization when filters are applied after window functions at 2012-05-24 19:55:21 from Bruce Momjian

pgsql-hackers by date

Next:	From: Alvaro Herrera	Date: 2012-05-16 13:39:13
	Subject: read() returns ERANGE in Mac OS X
Previous:	From: Tom Lane	Date: 2012-05-16 13:08:26
	Subject: Re: 9.2beta1 regression: pg_restore --data-only does not set sequence values any more