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

[PostGIS]

#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):

 I have been looking some more on this. I don't think that it is st_expand
 that uses all the power, but when we get over some border the planner
 decides to do the _st_dwithin before bbox comparasion.

 both _st_dwithin and st_expand has cost 1. I guess that makes it a little
 randomly wich one is calculated first.
 Is there a reason for that.
 I tried to give _st_dwithin cost 100 and that seems to solve the problem.

 /Nicklas

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