Skip to main content


For the past days I worked on optimizing the Synapse (Matrix) database. Pain in the rear-end. I managed to reduce it from some 300 GB to around 100 GB. Still insane how huge the database is. idk if I can do more...

Now I will try to optimize the Friendica database and start the move to the new servers, little by little. A lot of work ahead.....

#tromstuff

in reply to Joseph Hanson

It is a complicated issue with Matrix... see github.com/matrix-org/synapse/… - many are having similar issues. The database does not store any media file and yet it is so massive.
in reply to Tio

I had the same issue. It got 60gb on a single user instance and the images were offsite on R2. I stopped hosting one when infosec.exchange went up with their own
in reply to Joseph Hanson

Yeah we are also considering this...to not host our own instance. Seems like a pain...