diff options
| author | Sean Quah <8349537+squahtx@users.noreply.github.com> | 2022-11-10 19:02:27 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-11-10 19:02:27 +0000 |
| commit | b2c2b030798d0e74d3bf1afb4726465b53620638 (patch) | |
| tree | a93ecc29c3af6b3b701dfa36206a4e34b384c04c /synapse/util/caches/stream_change_cache.py | |
| parent | Quieter logging for stateres failure at missing prev events (#14346) (diff) | |
| download | synapse-b2c2b030798d0e74d3bf1afb4726465b53620638.tar.xz | |
Fix PostgreSQL sometimes using table scans for `event_search` (#14409)
PostgreSQL may underestimate the number of distinct `room_id`s in `event_search`, which can cause it to use table scans for queries for multiple rooms. Fix this by setting `n_distinct` on the column. Resolves #14402. Signed-off-by: Sean Quah <seanq@matrix.org>
Diffstat (limited to 'synapse/util/caches/stream_change_cache.py')
0 files changed, 0 insertions, 0 deletions