I've occasionally deleted the whole thing in !StatusNet. It took a few days to rebuild the avatar images for active subscriptions, and, of course, the media content is forever missing. I haven't not noticed that it creates database reference issues, but then the database for the !StatusNet instances seem to have other (self-inflicted) damage. Your mileage with !GNUsocial may vary from mine with !StatusNet.