Skip site navigation (1) Skip section navigation (2)

Slow query after upgrade to 8.4

From: Jared Beck <jared(at)singlebrook(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Leon Miller-Out <leon(at)singlebrook(dot)com>
Subject: Slow query after upgrade to 8.4
Date: 2009-09-23 16:38:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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:

Thank you very much in advance for any suggestions you may have,
Jared Beck

Jared Beck
Web Developer
Singlebrook Technology
(607) 330-1493


pgsql-performance by date

Next:From: Shiva RamanDate: 2009-09-23 18:25:07
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Previous:From: Magnus HaganderDate: 2009-09-23 07:58:30
Subject: Re: statement stats extra load?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group