Opened 13 years ago
Last modified 7 years ago
#1846 new enhancement
change missing_indexes_generate_script to use spgist if available
Reported by: | robe | Owned by: | robe |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS Fund Me |
Component: | tiger geocoder | Version: | master |
Keywords: | Cc: | woodbri |
Description
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
Change History (3)
comment:1 by , 12 years ago
Cc: | added |
---|
comment:2 by , 12 years ago
Milestone: | PostGIS 2.1.0 → PostGIS Future |
---|
Note:
See TracTickets
for help on using tickets.
we won't be supporting spgist in 2.1.0 so this by dependency needs punting