Re: Proposal: Log inability to lock pages during vacuum

On 12/17/14, 10:20 AM, Heikki Linnakangas wrote:
>>
>>> * Change the new bit in the errdetail. "could not acquire cleanup lock"
>>>     sounds too much like an error to me. "skipped %u pinned pages" maybe?
>>
>> Seems reasonable.
>
> Well, that's not always true either; when freezing, it doesn't skip the pinned pages, it waits for them.

Oops. :(

> I.e. this just says how many pages were pinned, without saying what was done about them. That's not very meaningful
toan average DBA, but that's true for many of the numbers printed in vacuum verbose.
 

In this case it'll mean people will be less likely to report that this is happening, but maybe that's OK. At least if
someonecomes to us with a problem we'll be able to get some info from them. I'll separately look into the vacuum docs
andsee if we can do a better job explaining the verbose output.
 

BTW, what is it about a dynamic message that makes it untranslatable? Doesn't the translation happen down-stream, so
thatat most we'd just need two translation messages? Or worst case we could have two separate elog calls, if we wanted
togo that route.
 
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com