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

[TECHER David]

Hi Jessica,

If you give us an example of SQL instructions you use perhaps someone 
could help you.

--david;

Jessica Richard a écrit :
> 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 
> <http://us.rd.yahoo.com/evt=48256/*http://travel.yahoo.com/;_ylc=X3oDMTFhN2hucjlpBF9TAzk3NDA3NTg5BHBvcwM1BHNlYwNncm91cHMEc2xrA2VtYWlsLW5jbQ-->on 
> Yahoo! Travel.
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   


	

	
		
___________________________________________________________________________ 
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com