summaryrefslogtreecommitdiff
path: root/packages/sql/search_indexes.postgresql_psycopg2.sql
AgeCommit message (Collapse)Author
2013-04-13Add additional pg_trgm indexes for quicker searchesDan McGee
This allows our normal keyword-based search to be index-optimized rather than always doing full table scans. It requires the pg_trgm extension which is shipped out of the box with any sane install of PostgreSQL. Signed-off-by: Dan McGee <dan@archlinux.org>