diff options
author | Erik Johnston <erik@matrix.org> | 2019-02-12 11:28:08 +0000 |
---|---|---|
committer | Erik Johnston <erik@matrix.org> | 2019-02-12 11:39:34 +0000 |
commit | 362d80b7706c7bcd57ea5ee3e8e38b31c7d1ad8b (patch) | |
tree | d91fbfe94f018fbadda47f087ce00efe92870075 /docs/metrics-howto.rst | |
parent | Merge pull request #4619 from matrix-org/rav/remove_docker_no_tls_hacks (diff) | |
download | synapse-362d80b7706c7bcd57ea5ee3e8e38b31c7d1ad8b.tar.xz |
Reduce user_ips bloat during dedupe background update
The background update to remove duplicate rows naively deleted and reinserted the duplicates. For large tables with a large number of duplicates this causes a lot of bloat (with postgres), as the inserted rows are appended to the table, since deleted rows will not be overwritten until a VACUUM has happened. This should hopefully also help ensure that the query in the last batch uses the correct index, as inserting a large number of new rows without analyzing will upset the query planner.
Diffstat (limited to 'docs/metrics-howto.rst')
0 files changed, 0 insertions, 0 deletions