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.