Re: log bind parameter values on error - Mailing list pgsql-hackers

From Greg Stark
Subject Re: log bind parameter values on error
Date
Msg-id CAM-w4HM=qyHP9ezcB75XxgHVHw5X5uxomCWsn76p2LfFXiXRVQ@mail.gmail.com
Whole thread Raw
In response to Re: log bind parameter values on error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: log bind parameter values on error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 9 Dec 2019 at 15:17, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Meh ... people will inevitably complain that they needed to see the
> whole value, and we'll end up having to add another configuration
> variable.  Let's not go there just yet.

I haven't been following this whole thread but my initial reaction is
that this particular configuration parameter would actually carry it's
weight.

While some people have applications where they know the expected size
of the data and can safely log the entire data to the logs other
people deal with user-supplied data that can be very large. It would
suck to have something like Gitlab dump entire merge diffs to the log
and those aren't even very large, probably under a megabyte. Some
users will have individual data that are up to 1GB....

-- 
greg



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: log bind parameter values on error
Next
From: Andres Freund
Date:
Subject: Re: [Proposal] Level4 Warnings show many shadow vars