[postgis-devel] [PostGIS] #1024: Change 3D relationship functions to use &&& instead of &&

PostGIS trac at osgeo.org
Mon Nov 14 00:04:36 PST 2011


#1024: Change 3D relationship functions to use &&& instead of &&
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  task     |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by nicklas):

 Hmm,

 "&& AND &&& AND _ST_3D
 That will catch both indexes and choose the cheapest one to test first"

 Does that mean it will use the cheapest to test or the one giving less job
 for the recheck?

 I mean I guess && is cheaper do do but it will sort away fewer records and
 send more of them for recheck. How smart is the planner?

 /Nicklas

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1024#comment:4>
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