Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Old dead users cause large number of inserts to event_push_actions #5569

Open
matrixbot opened this issue Dec 17, 2023 · 0 comments
Open

Old dead users cause large number of inserts to event_push_actions #5569

matrixbot opened this issue Dec 17, 2023 · 0 comments

Comments

@matrixbot
Copy link
Collaborator

matrixbot commented Dec 17, 2023

This issue has been migrated from #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)

@matrixbot matrixbot changed the title Dummy issue Old dead users cause large number of inserts to event_push_actions Dec 21, 2023
@matrixbot matrixbot reopened this Dec 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant