Re: bad execution plan for subselects containing windowing-function

Andreas Kretschmer <akretschmer@spamfence.net> writes:
> No question, this is a silly query, but the problem is the 2nd query: it
> is obviously not possible for the planner to put the where-condition
> into the subquery.

Well, yeah: it might change the results of the window functions.
I see no bug here.  Your second query asks for a much more complicated
computation, it's not surprising it takes longer.

            regards, tom lane