On 6 August 2015 at 07:55, Andreas Joseph Krogh <andreas@xxxxxxxxxx> wrote:
På onsdag 05. august 2015 kl. 20:25:25, skrev Maxim Boguk <maxim.boguk@xxxxxxxxx>:[snip]I think I know where issue is.The PostgreSQL planner unable pass join conditions into subquery with aggregate functions (it's well known limitation).[snip]I'm curious; will 9.5 help here as it has "WHERE clause pushdown in subqueries with window functions"?
I've not looked at the query in any detail, but that particular patch won't help as it only allows pushdown of predicate into subqueries with window functions where the predicate is part of all of the subquery's PARTITION BY clauses.
The query in question has no window clauses, so qual pushdown is not disabled for that reason.
Regards
David Rowley
--
David Rowley http://www.2ndQuadrant.com/
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
