[postgis-devel] [PostGIS] #1248: Increasing cost of spatial functions.

PostGIS trac at osgeo.org
Wed Oct 19 03:39:57 PDT 2011


#1248: Increasing cost of spatial functions.
---------------------+------------------------------------------------------
 Reporter:  SzymonG  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Simon,

 I believe we upped the costs of functions in 1.4 or 1.5 though not as high
 as you have them set.  Right now _ST_Intersects is set to 100.  Believe it
 or not it used to be 1 which is the default of C functions.

 We didn't want to risk upping it any more without more analysis since for
 more complex tasks it might skew it unfavorably.  Which version of
 Postgres are you using?  I think the way the planner deals with cost
 matrics has changed from 8.3 - current 9.1.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1248#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list