[postgis-users] Performance tuning PostGIS and understanding the explain statement

David Blasby dblasby at refractions.net
Tue Jun 17 09:09:48 PDT 2003


Benjamin,

It appears that you are doing about 5000 distance() calculations.  If 
your features and region polygons are quite complex, this could take an 
awfully long time.

Could you somehow send me your region2 and feature table and I can make 
a better guess as to why its so slow.

dave




More information about the postgis-users mailing list