Brad Koehn ☑️ February 19, 2023 4:50pm In which I reduce the size of my #Synapse #Matrix database by 80% by deleting rooms that nobody is using, and then cleaning up the 8 million rows that Synapse leaves behind when you “delete” a room. `state_groups` (& `state_groups_state` & `state_group_edges`) are not fully purged alongside the rooms · Issue #12821 · matrix-org/synapse While investigating my database size, I found that state_groups_state and state_groups hold many stale entries that reference old rooms that have long since been removed from rooms and all related ...