diff options
Diffstat (limited to 'dist')
| -rw-r--r-- | dist/search.sql | 21 |
1 files changed, 2 insertions, 19 deletions
diff --git a/dist/search.sql b/dist/search.sql index e68b3c9b3..f80ca049c 100644 --- a/dist/search.sql +++ b/dist/search.sql @@ -1,22 +1,5 @@ --- Run this section on Mastodon DB as Postgres superuser. -- +-- Before running db:migrate, run this on Mastodon DB as Postgres superuser. -- -- sudo -sHu postgres -- psql mastodon_production CREATE EXTENSION pg_trgm; - --- Run this section on Mastodon DB as Mastodon user. -- --- sudo -sHu mastodon -- psql mastodon_production - --- Drop old FTS implementation -- -DROP TRIGGER IF EXISTS tsvectorinsert ON statuses; -DROP TRIGGER IF EXISTS tsvectorupdate ON statuses; -DROP FUNCTION IF EXISTS tsv_update_trigger; -DROP INDEX IF EXISTS tsv_idx; -ALTER TABLE statuses DROP COLUMN IF EXISTS tsv; -DROP INDEX IF EXISTS index_statuses_on_text_trgm; -DROP INDEX IF EXISTS index_statuses_on_spoiler_text_trgm; - --- Create new trigram indexes -- -CREATE INDEX CONCURRENTLY IF NOT EXISTS index_statuses_on_normalized_text_trgm ON statuses USING GIN (normalized_text gin_trgm_ops); - --- Compact tables --- -VACUUM ANALYZE; +CREATE EXTENSION unaccent; |