Re: Slow HashAggregate/cache access - Mailing list pgsql-performance
På onsdag 05. august 2015 kl. 20:25:25, skrev Maxim Boguk <maxim.boguk@gmail.com>:
[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"?
http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-where-pushdown-with-window-function/
Are you able to try 9.5 and post the results?
Thanks.
-- 
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Attachment
pgsql-performance by date: