[postgis-tickets] [PostGIS] #3058: picksplit method for column 1 of index "nd_geometry_idx" failed

[PostGIS]

#3058: picksplit method for column 1 of index "nd_geometry_idx" failed
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey
     Type:  defect   |      Status:  new    
 Priority:  medium   |   Milestone:         
Component:  postgis  |     Version:  trunk  
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 Actually, I could also test performance as I have the old index built and
 could compare with the old and with the new.

 Same queries are run against the same data, in one case the old index is
 used (removing the new) and in the other case the new index is used
 (removing the old). Indexes removal happens in a transaction which is
 rolled back afterwards, so nothing is lost. Plans have been checked to all
 use an index scan.

 Runs with old index:
 {{{
  Total runtime: 18.324 ms
  Total runtime: 16.792 ms
  Total runtime: 635.775 ms
  Total runtime: 11.026 ms
  Total runtime: 15.693 ms
 }}}

 Runs with new index:
 {{{
  Total runtime: 16.001 ms
  Total runtime: 31.227 ms
  Total runtime: 192.585 ms
  Total runtime: 11.787 ms
  Total runtime: 26.770 ms
 }}}

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