[postgis-devel] [PostGIS] #230: st_expand seems to affect the execution order wich affects st_dwithin

PostGIS trac at osgeo.org
Wed Aug 5 07:12:51 PDT 2009


#230: st_expand seems to affect the execution order wich affects st_dwithin
----------------------+-----------------------------------------------------
  Reporter:  nicklas  |       Owner:  robe                     
      Type:  defect   |      Status:  assigned                 
  Priority:  medium   |   Milestone:  postgis 1.4.1            
 Component:  postgis  |     Version:  1.4                      
Resolution:           |    Keywords:  st_dwithin st_expand bbox
----------------------+-----------------------------------------------------
Comment (by nicklas):

 Ok
 I've learned a lot about how to understand the explain.
 Thanks :-)

 But I still don't get what the downside is to put cost 100 to _st_dwithin.
 The it starts using the index and it all looks fine... ,not ??

 I will look through your slides to learn more.

 Thanks
 Nicklas

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/230#comment:11>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS


More information about the postgis-devel mailing list