Re: log_line_prefix: make it possible to add the search_path

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Pierre Ducroquet <p(dot)psql(at)pinaraf(dot)info>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: log_line_prefix: make it possible to add the search_path
Date: 2022-07-25 09:52:41
Message-ID: 20220725095241.uc4khzuswchlh2va@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2022-Jul-25, Pierre Ducroquet wrote:

> This is great for performance, but several tools are lacking around this
> usecase by not showing the schema, one of them being log_line_prefix.

> The attached patch implements this, using %S. I've not written the
> documentation yet, since I'm not sure this would be acceptable as is, or if a
> more "generic" method should be used (I thought of %{name} to fetch an
> arbitrary GUC, but did not implement due to a lack of need for that feature)

It seems that this would be too noisy to be truly usable. What if we
emitted a log line when the variable changed, and the value that's in
use when the connection starts?

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el universo real se halla siempre
un paso más allá de la lógica" (Irulan)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2022-07-25 09:57:26 Re: Proposal to provide the facility to set binary format output for specific OID's per session
Previous Message Alvaro Herrera 2022-07-25 09:49:50 Re: Make name optional in CREATE STATISTICS