Re: Reducing the log spam

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Reducing the log spam
Дата
Msg-id f88513d4906001a599da3b5dfddee32e011fe5c8.camel@cybertec.at
обсуждение исходный текст
Ответ на Reducing the log spam  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-hackers
On Wed, 2024-03-06 at 10:50 -0500, Greg Sabino Mullane wrote:
> On Tue, Mar 5, 2024 at 7:55 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > My experience from the field is that a lot of log spam looks like
> >
> >   database/table/... "xy" does not exist
> >   duplicate key value violates unique constraint "xy"
>
> Forcibly hiding those at the Postgres level seems a heavy hammer for what is ultimately an application problem.

Yes... or no.  Lots of applications violate constraints routinely.
As long as the error is caught and handled, that's not a problem.

Whoever cares about the log messages can enable them.  My impression
is that most people don't care about them.

But thanks for your opinion.

Yours,
Laurenz Albe



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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: MERGE ... RETURNING
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: [PATCH] Exponential backoff for auth_delay