Hacker News new | ask | show | jobs
by 693471 2474 days ago
You really don't want Matrix. One year of Matrix to IRC bridge cost me about 30GB in Postgresql database to hold the state/logs of everything.

It was less than 500MB of plaintext irssi logs.

2 comments

Did you figure out what's with the 60x bloat? Badly denormalized and storing tons of metadata? Storing images/video?
badly denormalised; every state change stored a snapshot of all the state in the room. so everytime someone joined a room it snapshotted the state of everyone else in the room. it has now been improved massively, and there is scope for further fixes. sorry that the GP got bit by it.
This too keeps improving