diff --git a/sql/upgrades/135.sql b/sql/upgrades/135.sql --- a/sql/upgrades/135.sql +++ b/sql/upgrades/135.sql @@ -8,6 +8,6 @@ create extension if not exists pg_trgm; +create index on origin using gin (url gin_trgm_ops); +create index on origin using hash (url); drop index origin_type_url_idx; -create index concurrently on origin using gin (url gin_trgm_ops); -create index concurrently on origin using hash (url);