Re: [HACKERS] Long binded parameter value in the postgres log

2017-06-08 Thread Masahiko Sawada
On Thu, Jun 8, 2017 at 5:00 PM, Nikitin Nikolay wrote: > Hi! > > > > We insert many rows with long text and bytea (about 500 MB) values. In the > postgres config we set log_min_duration_statement to 120 seconds. > > If this statements work more 120 seconds then they will be written into the > post

[HACKERS] Long binded parameter value in the postgres log

2017-06-08 Thread Nikitin Nikolay
Hi! We insert many rows with long text and bytea (about 500 MB) values. In the postgres config we set log_min_duration_statement to 120 seconds. If this statements work more 120 seconds then they will be written into the postgres log with parameter values. As a result, the postgres log increases