@dumpsterqueer@ondergrond.org you can run
SELECT room_id, count(*) AS count
FROM state_groups_state
GROUP BY room_id
ORDER BY count DESC;

to get an idea for state groups per room, and then start compression for the biggest ones (only really makes sense if the numbers are big tho)