Re: [bug fix] Suppress "autovacuum: found orphan temp table" message - Mailing list pgsql-hackers

From MauMau
Subject Re: [bug fix] Suppress "autovacuum: found orphan temp table" message
Date
Msg-id 4FBAF7DB9FD34149937226B722A5D3B7@maumau
Whole thread Raw
In response to Re: [bug fix] Suppress "autovacuum: found orphan temp table" message  ("MauMau" <maumau307@gmail.com>)
Responses Re: [bug fix] Suppress "autovacuum: found orphan temp table" message  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
> From: "Andres Freund" <andres@2ndquadrant.com>
>> On 2014-07-18 23:38:09 +0900, MauMau wrote:
>>> So, I propose a simple fix to change the LOG level to DEBUG1.  I don't 
>>> know
>>> which of DEBUG1-DEBUG5 is appropriate, and any level is OK.  Could you
>>> include this in 9.2.9?
>>
>> Surely that's the wrong end to tackle this from. Hiding actual problems
>> is a seriously bad idea.
>
> No, there is no serious problem in the user operation in this situation. 
> Server crash cannot be avoided, and must be anticipated.  The problem is 
> that PostgreSQL makes users worried about lots of (probably) unnecessary 
> messages.

Is there any problem if we don't output the message?  According the past 
discussion in this community, the user can just ignore this message.  If 
there is no problem, and the customer asks, I'd like to propose it as one 
temporary measure.

Regards
MauMau




pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: IS NOT DISTINCT FROM + Indexing
Next
From: Tom Lane
Date:
Subject: Re: IS NOT DISTINCT FROM + Indexing