Ultimately I think it’s a moot point. The nature of the fediverse means that any time you make a post, that information propagates across multiple servers and databases. Any of those might be backed up, scraped, defederated from, or temporarily brought offline. Anything you purport to create, edit, or delete can be stuck in any conceivable intermediate state, entirely outside of your awareness or control without recourse.

This isn’t reddit, this data doesn’t become the property and responsibility of a single centralized entity. Everyone would be best served to return to the old internet adage that anything you publish should be considered permanent and public.