diff options
Diffstat (limited to 'migrations/2018-05-01-141548_add-users/up.sql')
| -rw-r--r-- | migrations/2018-05-01-141548_add-users/up.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/migrations/2018-05-01-141548_add-users/up.sql b/migrations/2018-05-01-141548_add-users/up.sql index bb358f47b537..222afc485afe 100644 --- a/migrations/2018-05-01-141548_add-users/up.sql +++ b/migrations/2018-05-01-141548_add-users/up.sql @@ -68,6 +68,8 @@ CREATE MATERIALIZED VIEW search_index AS JOIN users ta ON ta.id = t.author JOIN users pa ON pa.id = p.author; +CREATE INDEX idx_fts_search ON search_index USING gin(document); + -- And drop the old fields: ALTER TABLE posts DROP COLUMN author_name; ALTER TABLE posts DROP COLUMN author_email; |