diff options
| author | Erik Johnston <erikj@matrix.org> | 2023-11-16 15:19:35 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-11-16 15:19:35 +0000 |
| commit | 3e8531d3baf205733693f9ae8b43aa0b4c82b744 (patch) | |
| tree | b4a153c96b8a2dbea1e7dfa66fa9026afa3e9dad /changelog.d | |
| parent | Speed up persisting large number of outliers (#16649) (diff) | |
| download | synapse-3e8531d3baf205733693f9ae8b43aa0b4c82b744.tar.xz | |
Speed up deleting device messages (#16643)
Keeping track of a lower bound of stream ID where we've deleted everything below makes the queries much faster. Otherwise, every time we scan for rows to delete we'd re-scan across all the rows that have previously deleted (until the next table VACUUM).
Diffstat (limited to 'changelog.d')
| -rw-r--r-- | changelog.d/16643.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/16643.misc b/changelog.d/16643.misc new file mode 100644 index 0000000000..cc0cf0901f --- /dev/null +++ b/changelog.d/16643.misc @@ -0,0 +1 @@ +Speed up deleting of device messages when deleting a device. |