And in postgres soft delete is more expensive than a regular delete because it's effectively an insert and update, while delete is just an update.