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

On 2014-07-22 10:09:04 +0900, MauMau wrote:
> >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?

Yes. The user won't know that possibly gigabytes worth of diskspace
aren't freed.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services