[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-devel
Subject:    [postgis-devel] [PostGIS] #1846: change missing_indexes_generate_script to use spgist if available
From:       "PostGIS" <trac () osgeo ! org>
Date:       2012-05-30 21:13:34
Message-ID: 046.63b9702022970d9a8386e24f30f48fe3 () osgeo ! org
[Download RAW message or body]

#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. \
_______________________________________________ postgis-devel mailing list
postgis-devel@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel


[prev in list] [next in list] [prev in thread] [next in thread]