On 10/15/05, Brion Vibber
<brion-e+AXbWqSrlAAvxtiuMwx3w(a)public.gmane.org> wrote:
Deleted revisions are removed from the revision
table and copied to the
archive table. The only record of deletion time is in the logging table,
and that won't tell you which revision was deleted when.
So, deleted revs aren't included in dumps at all?
Deletes are relatively rare (sysop) occurrences, right?
Some numbers of the German Wikipedia during two weeks measured with
Special:log and Special:Newpages:
delete: 7.561
newpages: 7.438
newusers: 5.460
upload: 3.6302
move: 2.049
revert: ~1.500[1]
block: 721
protect: 365
rights: 6
recentchanges: > 150.000[2]
[1] estimate by number of edits containing "revert" in it's comment.
[2] estimate based on the last WikiStat numbers
You may wonder why there are more deletes but new pages but the
"newpages" log only contains pages that have not been deleted. In my
private opinion English Wikipedia does not delete enough
non-encyclopaedic articles (like the "List of films ordered by uses of
the word fuck" that is TOP 23[3] of the most viewed articles by the way)
but the number of deltes should be somewhat higher than in the German
Wikipedia. So I guess that there are almost 1.000 deletes a day because
so many people confound Wikipedia with a place where they can put any
nonsense. Have a look at