diff options
| author | Erik Johnston <erik@matrix.org> | 2022-06-30 15:05:49 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-06-30 14:05:49 +0000 |
| commit | a3a05c812dbffd143f9a58bdf050bfac9062ba02 (patch) | |
| tree | 3acea7c91732c3c0186d4c1452a1336f69831b9d /synapse/storage/databases/main | |
| parent | Merge branch 'develop' into release-v1.62 (diff) | |
| download | synapse-a3a05c812dbffd143f9a58bdf050bfac9062ba02.tar.xz | |
Add index to help delete old push actions (#13141)
Diffstat (limited to 'synapse/storage/databases/main')
| -rw-r--r-- | synapse/storage/databases/main/event_push_actions.py | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/synapse/storage/databases/main/event_push_actions.py b/synapse/storage/databases/main/event_push_actions.py index 80ca2fd0b6..3fadd0930b 100644 --- a/synapse/storage/databases/main/event_push_actions.py +++ b/synapse/storage/databases/main/event_push_actions.py @@ -1189,6 +1189,16 @@ class EventPushActionsStore(EventPushActionsWorkerStore): where_clause="highlight=1", ) + # Add index to make deleting old push actions faster. + self.db_pool.updates.register_background_index_update( + "event_push_actions_stream_highlight_index", + index_name="event_push_actions_stream_highlight_index", + table="event_push_actions", + columns=["highlight", "stream_ordering"], + where_clause="highlight=0", + psql_only=True, + ) + async def get_push_actions_for_user( self, user_id: str, |