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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]
Дата
Msg-id 5671.1110782402@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Question about accessing current row data inside trigger
Следующее
От: Janning Vygen
Дата:
Сообщение: Re: normal user dump gives error because of plpgsql