max / makenotwork

327 B · 9 lines History Blame Raw

1	-- no-transaction
2	--
3	-- GIN index behind the lexical tier of discover's projects mode. Column added
4	-- in 176. Separate file for the same reason as 177: a concurrent build has to
5	-- be the only statement in its migration.
6
7	CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_projects_search_tsv
8	ON projects USING GIN (search_tsv);
9