summary refs log tree commit diff
path: root/synapse/state
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2019-02-12 11:28:08 +0000
committerErik Johnston <erik@matrix.org>2019-02-12 11:39:34 +0000
commit362d80b7706c7bcd57ea5ee3e8e38b31c7d1ad8b (patch)
treed91fbfe94f018fbadda47f087ce00efe92870075 /synapse/state
parentMerge pull request #4619 from matrix-org/rav/remove_docker_no_tls_hacks (diff)
downloadsynapse-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 'synapse/state')
0 files changed, 0 insertions, 0 deletions