nostr:npub1n2yyvk46t4vsjgquj47wras72gffy4ggpgd8f8twav2zx74gpfdsxf02hh 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.

Reply to this note

Please Login to reply.

Discussion

No replies yet.