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

From Tom Lane
Subject Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]
Date
Msg-id 5671.1110782402@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Ron Mayer wrote:
>> 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.

> The log file is useful, but I think showing the VACUUM user is _more_
> useful than the log file.

I think that reasoning is fundamentally unsound, because (a) a lot of
people already do vacuuming via a cron job or autovacuum, and (b)
autovacuum is definitely the wave of the future.  So it's foolish
to design this messaging around the assumption that there will be
a human attentive to the on-line output from VACUUM.  We should be
ensuring that the message gets into the postmaster log --- whether
it gets sent to the client is secondary.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about accessing current row data inside trigger
Next
From: Janning Vygen
Date:
Subject: Re: normal user dump gives error because of plpgsql