element-hq / element-hq/synapse
Old dead users cause large number of inserts to event_push_actions
Open
A-Disk-Space
A-Performance
A-Push
O-Occasional
S-Minor
T-Defect
- Dominant language
- Python
- Stars
- 4.6k
- Forks
- 600
- Avg merge
- 5d 22h
- Merged PRs (30d)
- 51
Description
This issue has been migrated from [#5569](https://github.com/matrix-org/synapse/issues/5569).
---
matrix.org inserts a *lot* of rows into `event_push_actions` (and `_staging`) for users that have long since disappeared. We should do something to reduce that.
(We insert a row per user per room for each event that notifies people, so messages in large rooms cause a lot of rows to be inserted)
Contributor guide
Assessment
This issue has not been assessed yet.