Re: [bug fix] Suppress "autovacuum: found orphan temp table" message

From: "MauMau" <maumau307(at)gmail(dot)com>
To: "Andres Freund" <andres(at)2ndquadrant(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [bug fix] Suppress "autovacuum: found orphan temp table" message
Date: 2014-07-22 01:09:04
Message-ID: 4FBAF7DB9FD34149937226B722A5D3B7@maumau
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> From: "Andres Freund" <andres(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-07-22 01:51:08 Re: IS NOT DISTINCT FROM + Indexing
Previous Message Peter Geoghegan 2014-07-22 00:02:25 Re: IS NOT DISTINCT FROM + Indexing