Opened 12 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 woodbri, 12 years ago

Cc: woodbri added

comment:2 by robe, 11 years ago

Milestone: PostGIS 2.1.0PostGIS Future

we won't be supporting spgist in 2.1.0 so this by dependency needs punting

comment:3 by robe, 7 years ago

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.