Generally the best choice is Never. Most attachments are items that are kept even after being sent (for example a draft of a document) and so are not meant to be deleted.