So many databases are set up to "delete" a record by just marking the column is_deleted as true, and the record is not actually deleted. Meaning a lot of delete

So many databases are set up to "delete" a record by just marking the column is_deleted as true, and the record is not actually deleted. Meaning a lot of deleted data is around on disk somewhere but just ignored in most queries.