log_parameter_max_length_on_error

Type: integer
Défaut: 0 (0B)
Min: -1 (-1)
Max: 1073741823 (1073741823B)
Unité: B
Contexte: user
Redémarrer: false
Depuis: 13

If greater than zero, each bind parameter value reported in error messages is trimmed to this many bytes. Zero (the default) disables including bind parameters in error messages. -1 allows bind parameters to be printed in full. If this value is specified without units, it is taken as bytes.

Non-zero values of this setting add overhead, as PostgreSQL will need to store textual representations of parameter values in memory at the start of each statement, whether or not an error eventually occurs. The overhead is greater when bind parameters are sent in binary form than when they are sent as text, since the former case requires data conversion while the latter only requires copying the string.

Commentaires