@fabio
> Do you have a huge 100GB database and you want to clean up old stuff? Sorry, you can't. There are some non-official solutions for compacting the events, but they're all likely to break your db - and none worked so far in my case.
https://github.com/matrix-org/synapse/blob/develop/docs/admin_api/purge_history_api.md
WIP: https://github.com/matrix-org/synapse/blob/develop/docs/message_retention_policies.md
> Then you'll get all the join/leave events of that busy room on your db, with no way of deleting them, and nothing to do unless your users exit those rooms.
fair enough, room state doesn't get purged.
> Did you start your instance by toying with the default SQLite backend, and now that it's become big you want to move to Postgres? Sorry, no official guides provided, only unofficial procedures scattered across a bunch of blogs.
https://github.com/element-hq/synapse/blob/develop/docs/postgres.md#porting-from-sqlite
did that, worked fine.
> Do you want to change the name of your server? Sorry, you can't. All the events are tightly coupled to your server name. The advised solution is to simply start a new instance.
you can't just change half of an accounts identifier. you can't with other protocols like activitypub or mail either. they could add an event for account migration though, as clean solution.
like other software and protocols, matrix definitively has it's flaws (like that big groupchat rooms suck) but does other things right as well.