diff options
| author | Erik Johnston <erik@matrix.org> | 2021-07-15 16:02:12 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-07-15 16:02:12 +0100 |
| commit | 3acf85c85f62655077f8c4b466389de4a4183604 (patch) | |
| tree | beae5e7d0633a3c19ad0f3a970d138723b68f47f /synapse/storage/databases/main/stream.py | |
| parent | Merge branch 'master' into develop (diff) | |
| download | synapse-3acf85c85f62655077f8c4b466389de4a4183604.tar.xz | |
Reduce likelihood of Postgres table scanning `state_groups_state`. (#10359)
The postgres statistics collector sometimes massively underestimates the number of distinct state groups are in the `state_groups_state`, which can cause postgres to use table scans for queries for multiple state groups. We fix this by manually setting `n_distinct` on the column.
Diffstat (limited to 'synapse/storage/databases/main/stream.py')
0 files changed, 0 insertions, 0 deletions