Continuing the discussion from Introducing permanently delete post functionality:
Is it possible to create a list of links to all soft-deleted posts?
Also, I’d be interested to find out how much space they take up in the database.
Continuing the discussion from Introducing permanently delete post functionality:
Is it possible to create a list of links to all soft-deleted posts?
Also, I’d be interested to find out how much space they take up in the database.
I don’t think regular text posts take up much space in the database at all, though I don’t know how to measure that.
You should be able to create a list of all the soft-deleted posts using something based on WHERE posts.deleted_at IS NOT NULL
, though you may also want to pick out those posts which aren’t deleted themselves, but are attached to a deleted topic.
Would exporting the result to a file with data explorer be a good approximation of the space they take?
But I think it should be negligible whether we’re talking about disk space, memory consumption, loading speed or anything else.