[postgis-users] how to speed up a query of polygons which contain a point?

Li Li fancyerii at gmail.com
Mon Sep 20 05:00:08 PDT 2010


hi all,
    I use this condition in sql to get the polygons that contains this
point, is there any sql which utilize space index to speed up it?
    I use "where  ST_Contains(geom,ST_GeomFromText('POINT(116.355387
39.993801)',4326));" now. Thank you.



More information about the postgis-users mailing list