| From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Slow HashAggregate/cache access |
| Date: | 2015-08-05 19:55:58 |
| Message-ID: | VisenaEmail.a3.10149e4404053c2f.14eff6c96d4@tc7-visena |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
På onsdag 05. august 2015 kl. 20:25:25, skrev Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com
<mailto:maxim(dot)boguk(at)gmail(dot)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"?
Are you able to try 9.5 and post the results?
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexandre de Arruda Paes | 2015-08-05 20:53:25 | Re: Slow HashAggregate/cache access |
| Previous Message | Alexandre de Arruda Paes | 2015-08-05 19:29:36 | Re: Slow HashAggregate/cache access |