Hi út 5. 3. 2024 v 13:55 odesílatel Laurenz Albe <laurenz.a...@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 > > >
