Postgres Pro
Downloads
Home   >   mailing lists

Re: Reducing the log spam - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Reducing the log spam
Date
Msg-id CAFj8pRB40fwicFAv6S8_6b6U+XmsVp+mbd==cN14G_j1YrkdrQ@mail.gmail.com
Whole thread Raw
In response to Reducing the log spam  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
Tree view
Hi

út 5. 3. 2024 v 13:55 odesílatel Laurenz Albe <laurenz.albe@cybertec.at> napsal:
Inspired by feedback to [1], I thought about how to reduce log spam.

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"

So what about a parameter "log_suppress_sqlstates" that suppresses
logging ERROR and FATAL messages with the enumerated SQL states?

My idea for a default setting would be something like

  log_suppress_sqlstates = '23505,3D000,3F000,42601,42704,42883,42P01'

+1 in this form

the overhead of this implementation should be small

Regards

Pavel


but that's of course bikeshedding territory.

Yours,
Laurenz Albe



 [1]: https://postgr.es/m/b8b8502915e50f44deb111bc0b43a99e2733e117.camel%40cybertec.at


pgsql-hackers by date:

Previous
From: Yugo NAGATA
Date:
Subject: Remove unnecessary code from psql's watch command
Next
From: Robert Haas
Date:
Subject: Re: [PATCH] Exponential backoff for auth_delay