Bad optimization/planning on Postgres window-based queries (partition by(, group by?)) - 1000x speedup

From: and <and(dot)dietrich(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Bad optimization/planning on Postgres window-based queries (partition by(, group by?)) - 1000x speedup
Date: 2014-10-08 06:35:02
Message-ID: 1412750102410-5822190.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

see
http://stackoverflow.com/questions/26237463/bad-optimization-planning-on-postgres-window-based-queries-partition-by-group
for details

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Bad-optimization-planning-on-Postgres-window-based-queries-partition-by-group-by-1000x-speedup-tp5822190.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

Browse pgsql-performance by date

  From Date Subject
Next Message Vladimir Kamarzin 2014-10-08 08:40:23 Re: Performance degradation in 324577f39bc8738ed0ec24c36c5cb2c2f81ec660
Previous Message Andrew Dunstan 2014-10-07 21:27:58 Re: help: function failing