diff options
| author | Richard van der Hoff <github@rvanderhoff.org.uk> | 2016-07-25 14:04:05 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2016-07-25 14:04:05 +0100 |
| commit | bf3de7b90bbe4403980e77284f480a9a5c5ffc28 (patch) | |
| tree | 98578d9317298205cee33a6d67d1240a5af74c18 /synapse/storage/schema | |
| parent | Merge pull request #947 from matrix-org/rav/unittest_logging (diff) | |
| parent | PEP8 (diff) | |
| download | synapse-bf3de7b90bbe4403980e77284f480a9a5c5ffc28.tar.xz | |
Merge pull request #945 from matrix-org/rav/background_reindex
Create index on user_ips in the background
Diffstat (limited to 'synapse/storage/schema')
| -rw-r--r-- | synapse/storage/schema/delta/33/user_ips_index.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/synapse/storage/schema/delta/33/user_ips_index.sql b/synapse/storage/schema/delta/33/user_ips_index.sql index 8a05677d42..473f75a78e 100644 --- a/synapse/storage/schema/delta/33/user_ips_index.sql +++ b/synapse/storage/schema/delta/33/user_ips_index.sql @@ -13,4 +13,5 @@ * limitations under the License. */ -CREATE INDEX user_ips_device_id ON user_ips(user_id, device_id, last_seen); +INSERT INTO background_updates (update_name, progress_json) VALUES + ('user_ips_device_index', '{}'); |