Embed Notice
HTML Code
Corresponding Notice
- Embed this notice@mint @Yoruka @bajax @ctr @gav @iamtakingiteasy @kanon @lunarised @menherahair @pwm @s @shibao That's more useful but less humorous.
Actually in the earlier days I'd just grep the backups, which resulted in zero burden on the server, or I'd periodically load one of the old backups into another Postgres. (This was how I tested eliminating the Gab spam; eventually settled on eliminating activities from users that no one on FSE was following and that had no likes, and that severely reduced the size of the DB on-disk once it was dumped/restored again.)
If your main option is doing this kind of thing on the live server, it's actually helpful to break up the query so locks don't happen. Same way you'd do it if you were going through the API, just remember the last ID and do `where id < $the_last_one order by id`, things like that.
because.mp4