diff options
| author | Erik Johnston <erikj@element.io> | 2024-01-11 13:37:57 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-01-11 13:37:57 +0000 |
| commit | c43f751013489c7a037312455d4ee2793065ed6c (patch) | |
| tree | 7bf2226f3c9a0db977037a35a7617945966480e9 /changelog.d | |
| parent | Improve DB performance of calculating badge counts for push. (#16756) (diff) | |
| download | synapse-c43f751013489c7a037312455d4ee2793065ed6c.tar.xz | |
Optimize query for fetching to-device messages in `/sync` (#16805)
The current query supports passing in a list of users, which generates a query using `user_id = ANY(..)`. This is generates a less efficient query plan that is notably slower than a simple `user_id = ?` condition. Note: The new function is mostly a copy and paste and then a simplification of the existing function.
Diffstat (limited to 'changelog.d')
| -rw-r--r-- | changelog.d/16805.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/16805.misc b/changelog.d/16805.misc new file mode 100644 index 0000000000..0b54ab0f74 --- /dev/null +++ b/changelog.d/16805.misc @@ -0,0 +1 @@ +Optimize query for fetching to-device messages in `/sync`. |