Re: should we enable log_checkpoints out of the box?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: should we enable log_checkpoints out of the box?
Дата
Msg-id 20211105152622.GB19812@momjian.us
обсуждение исходный текст
Ответ на Re: should we enable log_checkpoints out of the box?  (Michael Banck <michael.banck@credativ.de>)
Список pgsql-hackers
On Fri, Nov  5, 2021 at 03:29:37PM +0100, Michael Banck wrote:
> Am Freitag, dem 05.11.2021 um 11:27 -0300 schrieb Alvaro Herrera:
> > On 2021-Nov-03, Jan Wieck wrote:
> > > On 11/3/21 09:09, Robert Haas wrote:
> > > 
> > > > For better or for worse, the distinction between ERROR, FATAL,
> > > > and
> > > > PANIC is entirely based on what we do after printing the message,
> > > > and NOT on how serious the message is.
> > > 
> > > THAT is a real problem with our error handling and logging system.
> > 
> > Agreed.
> 
> Well that, and the fact those distinctions are only done for user-
> facing events, whereas it seems to me we only distinguish between LOG
> and PANIC for server-facing events; maybe we need one or more
> additional levels here in order to make it easier for admins to see the
> really bad things that are happening?

Agreed.  We have three levels of non-error message for the client (info,
notice, warning), but only one level for error (query is stopped),
ERROR.  Seems we need another level that stops the current query and
indicates it contains information that would be useful for database
server administrators.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] rename column if exists
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: should we enable log_checkpoints out of the box?