diff options
| author | Erik Johnston <erik@matrix.org> | 2015-10-12 10:49:53 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-10-12 10:49:53 +0100 |
| commit | 61561b9df791ec90e287e535cc75831c2016bf36 (patch) | |
| tree | 903d6e26bc4bc3892c59c0a38bc9e2d3eccad96e /synapse/storage/schema/delta | |
| parent | Add basic full text search impl. (diff) | |
| download | synapse-61561b9df791ec90e287e535cc75831c2016bf36.tar.xz | |
Keep FTS indexes up to date. Only search through rooms currently joined
Diffstat (limited to 'synapse/storage/schema/delta')
| -rw-r--r-- | synapse/storage/schema/delta/24/fts.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/24/fts.py b/synapse/storage/schema/delta/24/fts.py index 5680332758..05f1605fdd 100644 --- a/synapse/storage/schema/delta/24/fts.py +++ b/synapse/storage/schema/delta/24/fts.py @@ -44,7 +44,8 @@ INSERT INTO event_search SELECT FROM events NATURAL JOIN event_json WHERE type = 'm.room.topic'; -CREATE INDEX event_search_idx ON event_search USING gin(vector); +CREATE INDEX event_search_fts_idx ON event_search USING gin(vector); +CREATE INDEX event_search_ev_idx ON event_search(event_id); """ |