diff options
| author | Erik Johnston <erik@matrix.org> | 2019-05-30 14:54:56 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2019-05-30 16:18:40 +0100 |
| commit | e2c3660a0ffb13d4198893e91a90ae1abcad8915 (patch) | |
| tree | 742e4b2c2dc1bf5cc131cc2115becf30e671ce21 | |
| parent | Update synapse/storage/events_bg_updates.py (diff) | |
| download | synapse-e2c3660a0ffb13d4198893e91a90ae1abcad8915.tar.xz | |
Add index to temp table
| -rw-r--r-- | synapse/storage/schema/delta/54/delete_forward_extremities.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/54/delete_forward_extremities.sql b/synapse/storage/schema/delta/54/delete_forward_extremities.sql index aa40f13da7..b062ec840c 100644 --- a/synapse/storage/schema/delta/54/delete_forward_extremities.sql +++ b/synapse/storage/schema/delta/54/delete_forward_extremities.sql @@ -20,3 +20,4 @@ INSERT INTO background_updates (update_name, progress_json) VALUES DROP TABLE IF EXISTS _extremities_to_check; -- To make this delta schema file idempotent. CREATE TABLE _extremities_to_check AS SELECT event_id FROM event_forward_extremities; +CREATE INDEX _extremities_to_check_id ON _extremities_to_check(event_id); |