I am using the following WFS filer against a postgis database <ogc:Filter> <ogc:DWithin> <ogc:PropertyName>vagis:the_geom</ogc:PropertyName> <gml:Point><gml:coordinates>-77.9001,38.875</gml:coordinates></gml:Point> <ogc:Distance>.02</ogc:Distance> </ogc:DWithin> </ogc:Filter>
I do have a gist spatial index on the "the_geom" attribute. However, when I look at the query sent to the postgis database it is not using the index. It looks like geoserver is trying to read all the records and then perform its own dwithin search rather than using postgis's function and index. We are using an old version of geoserver (1.7.6). Is there something I am doing wrong or is this a problem because I'm on an old version if geoserver? Is there a way to force the query to use the spatial index? Thanks in advance. David -- David R Robison Open Roads Consulting, Inc. 103 Watson Road, Chesapeake, VA 23320 phone: (757) 546-3401 e-mail: [email protected] web: http://openroadsconsulting.com blog: http://therobe.blogspot.com book: http://www.xulonpress.com/bookstore/bookdetail.php?PB_ISBN=9781597816526 ------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
