From b5192355f6ac11eec4781d73a59b14cfc8732d1f Mon Sep 17 00:00:00 2001 From: Erik Johnston Date: Fri, 14 Apr 2023 16:10:32 +0100 Subject: 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 --- changelog.d/15435.misc | 1 + 1 file changed, 1 insertion(+) create mode 100644 changelog.d/15435.misc (limited to 'changelog.d') 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. -- cgit 1.4.1