Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

Room retention *increases* size of state tables. #9406

Open
erikjohnston opened this issue Feb 15, 2021 · 2 comments
Open

Room retention *increases* size of state tables. #9406

erikjohnston opened this issue Feb 15, 2021 · 2 comments
Labels
A-Retention Retention rules to delete messages after a certain amount of time S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.

Comments

@erikjohnston
Copy link
Member

erikjohnston commented Feb 15, 2021 •
edited
Loading

We have reports that enabling room retention in a very large room (with frequent joins and leaves) actually causes the size of the state tables to increase, which is surprising.

Note that it appears that postgres is vacuuming the tables.

Also note that this is an experimental feature.
@erikjohnston erikjohnston added S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues. labels Feb 15, 2021
@erikjohnston
Copy link
Member Author

This also looks to be happening with the /purge_history admin API

@richvdh
Copy link
Member

richvdh commented Feb 18, 2021

possibly related to #3364 ?

@MadLittleMods MadLittleMods added the A-Retention Retention rules to delete messages after a certain amount of time label Dec 8, 2022
@matrixbot matrixbot mentioned this issue Dec 21, 2023
Open
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
A-Retention Retention rules to delete messages after a certain amount of time S-Minor Blocks non-critical functionality, workarounds exist. T-Defect Bugs, crashes, hangs, security vulnerabilities, or other reported issues.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@MadLittleMods @richvdh @erikjohnston