Currently, a non-freeze vacuum will punt on any page it can't get a cleanup lock on, with no retry. Presumably this
shouldbe a rare occurrence, but I think it's bad that we just assume that and won't warn the user if something bad is
goingon.
My thought is that if we skip any pages elog(LOG) how many we skipped. If we skip more than 1% of the pages we visited
(notrelpages) then elog(WARNING) instead.
Comments?
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com