summary refs log tree commit diff
path: root/synapse/storage/databases/main/session.py
diff options
context:
space:
mode:
authorNick Mills-Barrett <nick@fizzadar.com>2023-03-24 11:44:01 +0000
committerGitHub <noreply@github.com>2023-03-24 11:44:01 +0000
commite6af49fbea939d9e69ed05e0a0ced5948c722ea4 (patch)
tree19f8e755f5895247d03c3f1b7f5ac98effbde98c /synapse/storage/databases/main/session.py
parentAdd a primitive helper script for listing worker endpoints. (#15243) (diff)
downloadsynapse-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 'synapse/storage/databases/main/session.py')
0 files changed, 0 insertions, 0 deletions