I would seriously ponder: 1) copying the table of read_post and purging the live one. Re-integrate the data later. 2) copy out community table and purge any that aren’t active in past 3 weeks, re-integrate data later. 3) add index on post_aggregates community_id, 4) if that doesn’t work… put a limit of 1 month on the PostView query cut-off as an emergency performance measure.
Lemmy.world
I’ve talked a lot about drastic solutions.
I would seriously ponder: 1) copying the table of read_post and purging the live one. Re-integrate the data later. 2) copy out community table and purge any that aren’t active in past 3 weeks, re-integrate data later. 3) add index on post_aggregates community_id, 4) if that doesn’t work… put a limit of 1 month on the PostView query cut-off as an emergency performance measure.