diff options
| author | Erik Johnston <erik@matrix.org> | 2016-09-12 16:57:05 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2016-09-12 16:57:05 +0100 |
| commit | 0b32bb20bbf025b6e69bae23a6d4a96903f41885 (patch) | |
| tree | 2c1ae5d949cee601a4cf3890c9e49535af7eddac /synapse/storage/events.py | |
| parent | Add WHERE clause support to index creation (diff) | |
| download | synapse-0b32bb20bbf025b6e69bae23a6d4a96903f41885.tar.xz | |
Index contains_url for file search queries
Diffstat (limited to 'synapse/storage/events.py')
| -rw-r--r-- | synapse/storage/events.py | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/synapse/storage/events.py b/synapse/storage/events.py index ed182c8d11..6dc46fa50f 100644 --- a/synapse/storage/events.py +++ b/synapse/storage/events.py @@ -189,6 +189,14 @@ class EventsStore(SQLBaseStore): self._background_reindex_fields_sender, ) + self.register_background_index_update( + "event_contains_url_index", + index_name="event_contains_url_index", + table="events", + columns=["room_id", "topological_ordering", "stream_ordering"], + where_clause="contains_url = true AND outlier = false", + ) + self._event_persist_queue = _EventPeristenceQueue() def persist_events(self, events_and_contexts, backfilled=False): |