diff options
| author | Erik Johnston <erik@matrix.org> | 2021-01-14 16:47:21 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-01-14 16:47:21 +0000 |
| commit | 631dd06f2c7e9224602877d5bfcbca7695c4227e (patch) | |
| tree | 56368521eaeadddf034f445391b54bbbe5a97e67 /synapse/storage | |
| parent | Add background update for add chain cover index (#9029) (diff) | |
| download | synapse-631dd06f2c7e9224602877d5bfcbca7695c4227e.tar.xz | |
Fix get destinations to catch up query. (#9114)
t was doing a sequential scan on `destination_rooms`, which took minutes.
Diffstat (limited to 'synapse/storage')
| -rw-r--r-- | synapse/storage/databases/main/transactions.py | 24 |
1 files changed, 11 insertions, 13 deletions
diff --git a/synapse/storage/databases/main/transactions.py b/synapse/storage/databases/main/transactions.py index 59207cadd4..cea595ff19 100644 --- a/synapse/storage/databases/main/transactions.py +++ b/synapse/storage/databases/main/transactions.py @@ -464,19 +464,17 @@ class TransactionStore(TransactionWorkerStore): txn: LoggingTransaction, now_time_ms: int, after_destination: Optional[str] ) -> List[str]: q = """ - SELECT destination FROM destinations - WHERE destination IN ( - SELECT destination FROM destination_rooms - WHERE destination_rooms.stream_ordering > - destinations.last_successful_stream_ordering - ) - AND destination > ? - AND ( - retry_last_ts IS NULL OR - retry_last_ts + retry_interval < ? - ) - ORDER BY destination - LIMIT 25 + SELECT DISTINCT destination FROM destinations + INNER JOIN destination_rooms USING (destination) + WHERE + stream_ordering > last_successful_stream_ordering + AND destination > ? + AND ( + retry_last_ts IS NULL OR + retry_last_ts + retry_interval < ? + ) + ORDER BY destination + LIMIT 25 """ txn.execute( q, |