I’m investigating my sql dump because it took 15mb with only 3 post. I figure out that there is a table which is named “scheduler_stats” and it have about 40k lines of data. I just want to learn is it safe to clean this table with some sql query like “delete from scheduler_stats where id < 500;” ? Or may be there is a feature which is come with discourse by default for cleaning that table?
Also I found that it is possible to completely remove posts which is already “deleted” by :
DELETE FROM posts WHERE deleted_at IS NOT NULL; DELETE FROM topics WHERE deleted_at IS NOT NULL;
But I don’t sure about if this is safe or not…
Does anyone have any idea?