[postgis-users] query becomes much slower after Postgres 8.2.4 and Postgis 1.2.1 upgrade

[Jessica Richard]

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.

The slowness seems to come from the geospatial part of the query because without the geospatial part, the query would come back a lot quicker, but the entire query ran a lot faster before all of those upgrades.

Has any one seen this performance issue after the upgrade before?
Is there anything I can do to fix this?

Thanks a lot,
Jessica
       
---------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070516/d3cfb9f6/attachment.html>