summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2015-04-07 12:09:36 +0100
committerErik Johnston <erik@matrix.org>2015-04-07 12:09:36 +0100
commit8574bf62dc27ec3c2059c57a32c955e85d7e51df (patch)
treee0064f5d9052b07eaf49f94c36266559b18b6cb1 /synapse/storage/schema/delta
parentDon't use multiple UNIQUE constraints; it will cause deadlocks (diff)
downloadsynapse-8574bf62dc27ec3c2059c57a32c955e85d7e51df.tar.xz
Add index to presence table
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/15/presence_indices.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/15/presence_indices.sql b/synapse/storage/schema/delta/15/presence_indices.sql
new file mode 100644
index 0000000000..6b8d0f1ca7
--- /dev/null
+++ b/synapse/storage/schema/delta/15/presence_indices.sql
@@ -0,0 +1,2 @@
+
+CREATE INDEX IF NOT EXISTS presence_list_user_id ON presence_list (user_id);