query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade
Date: 2007-05-15 19:49:54
Message-ID: 785900.84546.qm@web56411.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We had the following upgrades last week:

proj-4.4.9 to proj-4.5.0
geos-2.2.1 to geos-2.2.3
Postgis 1.1.1 to Postgis 1.2.1,
then
Postgres 8.1.4 to 8.2.4

After the entire upgrades, a same query with geospatial functions that used to come back in a few minutes, now take about 3 minutes to finish, no erors, just much slower than before.

Has any one seen this performance issue after the upgrade before?

Thanks a lot,
Jessica


---------------------------------
Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nykolyn, Andrew 2007-05-15 21:43:06 Problem Recovering from Windows PITR
Previous Message Johann Spies 2007-05-15 10:50:42 Re: ERROR: invalid memory alloc request size