summary refs log tree commit diff
path: root/synapse/storage/schema
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2019-05-30 14:54:56 +0100
committerErik Johnston <erik@matrix.org>2019-05-30 15:02:31 +0100
commit6cdfb0207e2de72286a7a8d3b3c417c2808e90dc (patch)
tree38b1c6741d05e0412bd563832dc5a02eed4675b0 /synapse/storage/schema
parentMerge pull request #5278 from matrix-org/erikj/cleanup_bad_extremities (diff)
downloadsynapse-6cdfb0207e2de72286a7a8d3b3c417c2808e90dc.tar.xz
Add index to temp table
Diffstat (limited to 'synapse/storage/schema')
-rw-r--r--synapse/storage/schema/delta/54/delete_forward_extremities.sql1
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);