[postgis-devel] [PostGIS] #1846: change missing_indexes_generate_script to use spgist if available

PostGIS trac at osgeo.org
Wed May 30 14:13:34 PDT 2012


#1846: change missing_indexes_generate_script to use spgist if available
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  robe         
     Type:  enhancement     |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.1.0
Component:  tiger geocoder  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 At a cursory glance it seems spgist on character fields performs better
 than btree for LIKE searches and LIKE seems to work fine with it.  Still
 need to do some benchmarking, but since we have a script to generate the
 indexes, it is easy to swap out btree in favor of spgist if a user is
 running 9.2+ and reap the benefits without making any of the geocoder
 query logic 9.2 specific

 This just required a change to to check the version of PostgreSQL and use
 spgist if available
 http://www.postgis.org/documentation/manual-
 svn/Missing_Indexes_Generate_Script.html

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1846>
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