Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]
Date: 2005-03-13 06:11:44
Message-ID: 4233D9A0.1040300@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2005-03-13 11:13:38 Re: General query optimization howto
Previous Message Russell Smith 2005-03-13 06:11:34 Re: Using sequence name depending on other column

Browse pgsql-patches by date

  From Date Subject
Next Message Marko Kreen 2005-03-13 09:12:53 Re: pgcrypto: openssl digest fix
Previous Message Bruce Momjian 2005-03-13 05:42:11 Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]