Add DB indices to speed up purging rooms

matrix-org / synapse

Synapse: Matrix homeserver written in Python/Twisted.

https://matrix-org.github.io/synapse

Apache License 2.0

11.83k stars 2.13k forks source link

Closed DMRobertson closed 1 year ago

DMRobertson commented 1 year ago

We have seen DELETEs from these tables clog up the background process worker on matrix.org. Indices should help.

Completely untested.

clokep commented 1 year ago

Is this in lieu of #16102?

DMRobertson commented 1 year ago

Pretty much yeah. I haven't been following the details; Erik asked me to PR this so we at least have the option of a stopgap.

erikjohnston commented 1 year ago

Yes it is