[postgis-devel] [PostGIS] #1165: Selectivity extimation of && operator

[PostGIS]

#1165: Selectivity extimation of && operator
----------------------------+-----------------------------------------------
 Reporter:  edoardopanfili  |       Owner:  pramsey      
     Type:  defect          |      Status:  new          
 Priority:  blocker         |   Milestone:  PostGIS 2.0.0
Component:  postgis         |     Version:  1.5.X        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by strk):

 > I blame this slowness on all the liblwgeom/libpgcommon shuffling.

 This is false advertisement !
 Go back to a pre-libpgcommon/liblwgeom snapshot and banchmark it.
 Then, if still possible, try with and w/out GSERIALIZED.

 Even better, bisect the repository (git has a nice support for this).

 I'll bet on forced recomputation of bounding box takin up the most time
 (I belive I've seen a spot where box3d are continuously computed rather
 than cached
 and I reported on list IIRC w/out replies)

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