Our site has a lot of good content with lasting value.
It also has quite a bit of poor content - primarily old, closed questions that do not qualify for the automatic cleanup processes.
To summarize briefly the main cases where system deletion occurs:
Closed, unlocked questions with zero or negative score having no positively scored or accepted answers or pending reopen votes, that were closed for any reason other than duplicate nine or more days ago and haven't been edited in the past nine days. (RemoveAbandonedClosed)
Negatively-scored, unlocked, and unanswered questions that are older than 30 days. (RemoveDeadQuestions)
Unanswered questions older than 365 days on main (non-meta) sites with score of zero (or one, if the owner's account is deleted), fewer than 1.5 views per day on average, and fewer than two comments. (RemoveAbandonedQuestions)
This automatic process covers a good fraction of content that we don't want to keep around, but there are some obvious gaps in the logic, for example poor-quality questions that somehow managed a positive score, avoided being closed, or gained one or more positively-scored answers.
In theory, users with the Access To Moderator Tools or Trusted User privilege would carefully review these questions and cast delete votes when appropriate. Even questions with (accepted) answers can be deleted this way, and it normally only needs three such votes.
We have 26 users with the Trusted User (20k) privilege and 61 with Access To Moderator Tools (10k). Still, deletion without system or diamond moderator action rarely happens in practice.
This is partly due to the fact that 10k users have to wait for a question to be closed for 2 days before they can vote for deletion. This restriction is removed for 20k users if the question scores -3 or lower, but they are still encouraged to wait.
The simple reality is that people with the power to delete don't often encounter questions that ought to be deleted, when they are able to delete them.
The system does not provide a queue of questions for 'delete review', nor a usable queue of questions on which a delete vote has already been cast. Given the queue of feature requests and the very limited development time available, it is unlikely we will see a system solution in the short term.
There are currently 3,869 questions that are closed (not as a duplicate) and inactive for at least 9 days. Some (probably small) number of these will offer no lasting value to our site and might need to be deleted.
- Odd syntax error when creating view with SCHEMABINDING
- Foreign Key Error
- Getting a error message SQL
- why this query not update table
- trigger is not working properly
- How to return a single column value using a PostgreSQL function?
- how to insert into tables in sql server?
- What do you think should happen to closed questions long-term?
- Would you be interested in contributing to the cleanup of valueless content?
- If so, how should we coordinate this (long-term) effort? (some sites use a dedicated chat room)
- For those of you with the power to vote to delete, what stops you using these votes?
- Any other concerns?
Input from everyone is encouraged - not just 10k+ users. Identifying content that ought to be deleted is something anyone should be able to do.