Slow query after upgrade to 8.4
От | Jared Beck |
---|---|
Тема | Slow query after upgrade to 8.4 |
Дата | |
Msg-id | 855bf1c00909231353x63d1f3ffoc9f5afe03f04feec@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Slow query after upgrade to 8.4
Re: Slow query after upgrade to 8.4 |
Список | pgsql-performance |
Hello postgres wizards, We recently upgraded from 8.1.5 to 8.4 We have a query (slow_query.sql) which took about 9s on 8.1.5 On 8.4, the same query takes 17.7 minutes. The code which generated this query is written to support the calculation of arbitrary arithmetic expressions across "variables" and "data" within our application. The example query is a sum of three "variables", but please note that because the code supports arbitrary arithmetic, we do not use an aggregate function like sum() We have collected as much information as we could and zipped it up here: http://pgsql.privatepaste.com/download/a3SdI8j2km Thank you very much in advance for any suggestions you may have, Jared Beck -- ------------------ Jared Beck Web Developer Singlebrook Technology (607) 330-1493 jared@singlebrook.com
В списке pgsql-performance по дате отправления: