Re: A way to let Vacuum warn if FSM settings are low. [final?] - Mailing list pgsql-patches

From Ron Mayer
Subject Re: A way to let Vacuum warn if FSM settings are low. [final?]
Date
Msg-id 4233D9A0.1040300@cheapcomplexdevices.com
Whole thread Raw
In response to Re: A way to let Vacuum warn if FSM settings are low. [final?]  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: A way to let Vacuum warn if FSM settings are low. [final?]  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian wrote:
>
> You didn't like server_min_messages = 'notify'?

I merely don't have a feeling for how much additional stuff
verbose would be putting in the log files.

If it's a good practice for production systems to be logging
NOTIFY's I'm happy with the change.


My reasoning why I thought the log file was more useful was
that only an admin with access to the log files could really
do anything about the message anyway.

Also since the message happing occasionally is probably OK,
yet if it happens a lot it's more likely worth looking
into - I think the historical record of when it happened
is more interesting than a one-time occurrence which is
all you seen in the active session.

    Ron

PS: I'm fine either way; and perhaps it's a good idea
for me to be logging NOTIFY's anyway -- I just thought
I'd explain my reasoning above.  I'm sure you guys know
a lot more than me what best practices would be.

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: A way to let Vacuum warn if FSM settings are low. [final?]
Next
From: Marko Kreen
Date:
Subject: Re: pgcrypto: openssl digest fix