Postgres 8.3 vs. 8.4 - Query plans and performance

From: Jo <jl(dot)news(at)uni-bonn(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres 8.3 vs. 8.4 - Query plans and performance
Date: 2011-03-14 10:39:13
Message-ID: ilkr7u$a40$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

we have performance problems running several queries pon postgres 8.4 .
Using the previous version (8.3) our queries performs well
(The queries are quite complex, consisting of several sub-queries and
various spatial functions).

Using a new server with debian squeeze and postgres 8.4 from the
aptitude packages our queries won't finish and uses a lot of CPU time
(the used CPU runs mainly at 100%).

Indizes and datasets of the two databases are the same.
Regarding to the query plans there are some differences between the two
versions (using the same queries and after running VACUUM).

Are there some major changes from 8.3 to 8.4 that cause this bad
performance?

Regards,

Jo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Erven 2011-03-14 13:15:51 Re: Postgres 8.3 vs. 8.4 - Query plans and performance
Previous Message Vogt, Michael 2011-03-14 09:24:17 Autocommit off - commits/rollbacks