[postgis-users] Performance Updates

Paul Ramsey pramsey at refractions.net
Thu Jun 28 13:31:59 PDT 2007


FYI, this commit:

mleslie * r2634 /trunk/lwgeom/ (6 files):
Added a 1D rtree for polygon segment indexing, and tied the index  
into the point
in polygon short-circuit of the contains, within, intersects and  
disjoint
methods. Added an index cache to the comparitor methods to save index  
build

Should cause the above predicates in the point/polygon case to be  
blazingly fast now, not for individual cases, but for repeated tests  
(as in a spatial join situation).  Similar improvements to the  
general geometry/geometry case are going into JTS now, and will be  
available for PostGIS/JTS shortly thereafter.  General GEOS  
availability will have to wait for a porting update.



More information about the postgis-users mailing list