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

Incorperate Levans' guide into official documentation #14395

Open
aaronraimist opened this issue Nov 8, 2022 · 2 comments
Open

Incorperate Levans' guide into official documentation #14395

aaronraimist opened this issue Nov 8, 2022 · 2 comments
Labels
A-Docs things relating to the documentation O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Minor Blocks non-critical functionality, workarounds exist. T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.

Comments

@aaronraimist
Copy link
Contributor

The author of https://levans.fr/shrink-synapse-database.html said the blog post may disappear in the next few months https://matrix.to/#/!ehXvUhWNASUkSLvAGP:matrix.org/$gb32QeAGPqopUPI2zlQTC7MHV8PAJYsrMKTmqPIh-LM?via=matrix.org&via=libera.chat&via=matrix.breakpointingbad.com

Worst case scenario people can continue to send links to the Wayback Machine archive https://web.archive.org/web/20221107150752/https://levans.fr/shrink-synapse-database.html but it would be nice to add the guide to admin_faq.md or somewhere else in the official documentation

@squahtx squahtx added A-Docs things relating to the documentation T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks. S-Minor Blocks non-critical functionality, workarounds exist. O-Uncommon Most users are unlikely to come across this or unexpected workflow labels Nov 8, 2022
@DMRobertson
Copy link
Contributor

TL;DR:

  1. manually purge forgotten rooms, in lieu of
  2. run the state compressor on sufficiently large rooms
  3. reindex and vacuum full

Synapse should do (1) itself ( #4720); we'd like it to do (2) itself too. (3) is best left to the discretion of the database administrator: both REINDEX and VACUUM FULL require exclusive locks on tables. (There is REINDEX CONCURRENTLY, but it comes with several caveats.)

@clokep
Copy link
Member

clokep commented Nov 9, 2022

(2) run the state compressor on sufficiently large rooms

we'd like it to do (2) itself too.

See #10857

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
A-Docs things relating to the documentation O-Uncommon Most users are unlikely to come across this or unexpected workflow S-Minor Blocks non-critical functionality, workarounds exist. T-Task Refactoring, removal, replacement, enabling or disabling functionality, other engineering tasks.
Projects
None yet
Development

No branches or pull requests

4 participants