summary refs log tree commit diff
path: root/synapse/storage/schema/delta
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2017-09-28 14:10:33 +0100
committerErik Johnston <erik@matrix.org>2017-09-28 14:10:33 +0100
commit4dc07e93a85f0f6e09a6763a7833ef935be1c417 (patch)
treead8165686ea4d8e6c40f9c0f4ad1a1ae5fb4865d /synapse/storage/schema/delta
parentClear up expired url cache every 10s (diff)
downloadsynapse-4dc07e93a85f0f6e09a6763a7833ef935be1c417.tar.xz
Add old indices
Diffstat (limited to 'synapse/storage/schema/delta')
-rw-r--r--synapse/storage/schema/delta/44/expire_url_cache.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/synapse/storage/schema/delta/44/expire_url_cache.sql b/synapse/storage/schema/delta/44/expire_url_cache.sql
index 9475d53e84..e2b775f038 100644
--- a/synapse/storage/schema/delta/44/expire_url_cache.sql
+++ b/synapse/storage/schema/delta/44/expire_url_cache.sql
@@ -34,3 +34,5 @@ DROP TABLE local_media_repository_url_cache;
 ALTER TABLE local_media_repository_url_cache_new RENAME TO local_media_repository_url_cache;
 
 CREATE INDEX local_media_repository_url_cache_expires_idx ON local_media_repository_url_cache(expires_ts);
+CREATE INDEX local_media_repository_url_cache_by_url_download_ts ON local_media_repository_url_cache(url, download_ts);
+CREATE INDEX local_media_repository_url_cache_media_idx ON local_media_repository_url_cache(media_id);