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

Jessica Richard rjessil at yahoo.com
Wed May 16 05:01:07 PDT 2007


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>


More information about the postgis-users mailing list