Re: log bind parameter values on error

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>
To: Alexey Bashtanov <bashtanov@imap.cc>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-02-14T20:23:52Z
Lists: pgsql-hackers
Hi,

On 2018-12-14 23:04:26 +0000, Alexey Bashtanov wrote:
> Unfortunately, when enabled, the feature comes with some memory and CPU
> overhead,
> as we cannot convert certain values to text when in aborted transaction.

Have you analyzed how invasive it'd be to delay that till we actually
can safely start a [sub]transaction to do that logging? Probably too
expensive, but it seems like something that ought to be analyzed.

- Andres


Commits

  1. Emit parameter values during query bind/execute errors

  2. Add backend-only appendStringInfoStringQuoted