diff options
| author | Erik Johnston <erik@matrix.org> | 2023-05-03 14:42:43 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-05-03 13:42:43 +0000 |
| commit | 28ac1a1a91c972c19649e21a6e8d92bb786d8a57 (patch) | |
| tree | e426fa952df06f82aa09119f64879d6bf1c54b66 /changelog.d | |
| parent | Speed up rebuilding of the user directory for local users (#15529) (diff) | |
| download | synapse-28ac1a1a91c972c19649e21a6e8d92bb786d8a57.tar.xz | |
Speed up deleting of old rows in `event_push_actions` (#15531)
Enforce that we use index scans (rather than seq scans), which we also do for state queries. The reason to enforce this is that we can't correctly get PostgreSQL to understand the distribution of `stream_ordering` depends on `highlight`, and so it always defaults (on matrix.org) to sequential scans.
Diffstat (limited to 'changelog.d')
| -rw-r--r-- | changelog.d/15531.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/15531.misc b/changelog.d/15531.misc new file mode 100644 index 0000000000..6d4da961b5 --- /dev/null +++ b/changelog.d/15531.misc @@ -0,0 +1 @@ +Speed up deleting of old rows in `event_push_actions`. |