diff options
| author | Vincent Ambo <tazjin@gmail.com> | 2018-04-14T18·27+0200 |
|---|---|---|
| committer | Vincent Ambo <github@tazj.in> | 2018-04-14T20·21+0200 |
| commit | 2d8db520107c25c5bc7d1ba861047fa9b7eaea5f (patch) | |
| tree | 3fd6ab26754606921118bad7fec0d9b54d9ad1bb /migrations/2018-04-14-170750_search-index/down.sql | |
| parent | 529da884da2a208ad91aebf052522517a704c742 (diff) | |
feat(migrations): Add materialized view & index for full text search
Adds a materialized view to be used for full-text searches that indexes the tsvector documents for each post.
Diffstat (limited to 'migrations/2018-04-14-170750_search-index/down.sql')
| -rw-r--r-- | migrations/2018-04-14-170750_search-index/down.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/migrations/2018-04-14-170750_search-index/down.sql b/migrations/2018-04-14-170750_search-index/down.sql new file mode 100644 index 000000000000..c57e66290201 --- /dev/null +++ b/migrations/2018-04-14-170750_search-index/down.sql @@ -0,0 +1,2 @@ +DROP INDEX idx_fts_search; +DROP MATERIALIZED VIEW search_index; |