[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