diff options
| author | Nick Mills-Barrett <nick@fizzadar.com> | 2023-03-24 11:44:01 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-03-24 11:44:01 +0000 |
| commit | e6af49fbea939d9e69ed05e0a0ced5948c722ea4 (patch) | |
| tree | 19f8e755f5895247d03c3f1b7f5ac98effbde98c /changelog.d/15128.misc | |
| parent | Add a primitive helper script for listing worker endpoints. (#15243) (diff) | |
| download | synapse-e6af49fbea939d9e69ed05e0a0ced5948c722ea4.tar.xz | |
Reintroduce membership tables event stream ordering (#15128)
* Add `event_stream_ordering` column to membership state tables Specifically this adds the column to `current_state_events`, `local_current_membership` and `room_memberships`. Each of these tables is regularly joined with the `events` table to get the stream ordering and denormalising this into each table will yield significant query performance improvements once used. * Make denormalised `event_stream_ordering` columns foreign keys * Add comment in schema file explaining new denormalised columns * Add triggers to enforce consistency of `event_stream_ordering` columns * Re-order purge room tables to account for foreign keys * Bump schema version to 75 Co-authored-by: David Robertson <david.m.robertson1@gmail.com> Co-authored-by: Richard van der Hoff <1389908+richvdh@users.noreply.github.com>
Diffstat (limited to 'changelog.d/15128.misc')
| -rw-r--r-- | changelog.d/15128.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/15128.misc b/changelog.d/15128.misc new file mode 100644 index 0000000000..c09911e48d --- /dev/null +++ b/changelog.d/15128.misc @@ -0,0 +1 @@ +Add denormalised event stream ordering column to membership state tables for future use. Contributed by Nick @ Beeper (@fizzadar). |