diff options
| author | Nick Mills-Barrett <nick@beeper.com> | 2023-02-07 01:10:54 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-02-07 00:10:54 +0000 |
| commit | 5fdc12f482c68e2cdbb78d7db5de2cfe621720d4 (patch) | |
| tree | cdef22657811ba7e2541d712bb8c840f6f27b242 /changelog.d | |
| parent | Allow poetry-core 1.5.0 (#14949) (diff) | |
| download | synapse-5fdc12f482c68e2cdbb78d7db5de2cfe621720d4.tar.xz | |
Add `event_stream_ordering` column to membership state tables (#14979)
This adds an `event_stream_ordering` 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. Includes a background job to populate these values from the `events` table. Same idea as https://github.com/matrix-org/synapse/pull/13703. Signed off by Nick @ Beeper (@fizzadar).
Diffstat (limited to 'changelog.d')
| -rw-r--r-- | changelog.d/14979.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/14979.misc b/changelog.d/14979.misc new file mode 100644 index 0000000000..c09911e48d --- /dev/null +++ b/changelog.d/14979.misc @@ -0,0 +1 @@ +Add denormalised event stream ordering column to membership state tables for future use. Contributed by Nick @ Beeper (@fizzadar). |