Drupal n00b here. I'm having trouble getting my head around the automatic file renaming that happens with content types that have publishing/moderation options. I've found a number of discussions relating to this topic, but no real resolution (that I could understand).
We now have thousands of files on our server, many with the "file_0.pdf", "file_1.pdf" naming situation. It's my understanding that these are related to the process of publishing content using the "draft->needs review->published" workflow.