summary refs log tree commit diff
path: root/changelog.d/15435.misc
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2023-04-14 16:10:32 +0100
committerGitHub <noreply@github.com>2023-04-14 16:10:32 +0100
commitb5192355f6ac11eec4781d73a59b14cfc8732d1f (patch)
tree3c4f2e0d40e254dbb8de2d187b2e3e1d49559012 /changelog.d/15435.misc
parentDelete pushers after calling on_logged_out module hook on device delete (#15410) (diff)
downloadsynapse-b5192355f6ac11eec4781d73a59b14cfc8732d1f.tar.xz
User directory background update speedup (#15435)
c.f. #15264

The two changes are:
1. Add indexes so that the select / deletes don't do sequential scans
2. Don't repeatedly call `SELECT count(*)` each iteration, as that's slow
Diffstat (limited to 'changelog.d/15435.misc')
-rw-r--r--changelog.d/15435.misc1
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/15435.misc b/changelog.d/15435.misc
new file mode 100644
index 0000000000..e0f591b6d1
--- /dev/null
+++ b/changelog.d/15435.misc
@@ -0,0 +1 @@
+Speed up the user directory background update.