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
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
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 |