diff options
| author | Brendan Abolivier <babolivier@matrix.org> | 2019-11-07 11:49:37 +0000 |
|---|---|---|
| committer | Brendan Abolivier <babolivier@matrix.org> | 2019-11-07 11:51:11 +0000 |
| commit | 3f9b61ff9504dd88cac17fb3cb097e319babd2a3 (patch) | |
| tree | 470d8df6be60f7f6b3879a980acf0098a553072a /test_postgresql.sh | |
| parent | Fix bug which caused rejected events to be stored with the wrong room state ... (diff) | |
| download | synapse-3f9b61ff9504dd88cac17fb3cb097e319babd2a3.tar.xz | |
Fix the SQL SELECT query in _paginate_room_events_txn
Doing a SELECT DISTINCT when paginating is quite expensive, because it requires the engine to do sorting on the entire events table. However, we only need to run it if we're filtering on 2+ labels, so this PR is changing the request so that DISTINCT is only used then.
Diffstat (limited to 'test_postgresql.sh')
0 files changed, 0 insertions, 0 deletions