Fabio Manganiello on Nostr: npub1n2yyv…f02hh I've also found this but this tool also seem to work only on ...

npub1n2yyvk46t4vsjgquj47wras72gffy4ggpgd8f8twav2zx74gpfdsxf02hh (npub1n2y…02hh) I've also found this https://github.com/erikjohnston/synapse-find-unreferenced-state-groups but this tool also seem to work only on Postgres. I don't seem to find a reliable way of compacting/purging that table without first migrating to Postgres. Since many admins consider migrating to Postgres only after bumping into disk space / performance issues with state_groups_state, it'd be nice to have a tool that does it directly on SQLite without having to do two rounds.