Re: improve DEBUG1 logging of parallel workers for CREATE INDEX?

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Sami Imseih <samimseih(at)gmail(dot)com>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: improve DEBUG1 logging of parallel workers for CREATE INDEX?
Date: 2025-01-08 20:46:39
Message-ID: CAECtzeW+hUHM9u=E+H5d3b_GvXy5Ei0=d9TwjVKBMS9OTa=bxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le mer. 8 janv. 2025 à 21:35, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> a écrit :

> Guillaume Lelarge <guillaume(at)lelarge(dot)info> writes:
> > I tend to agree it might be better than Benoit's patch on the index
> > messages, though I'm afraid that DEBUG1 level won't work for many users.
> > DEBUGx are for developers, not users. A better log level for me would be
> > LOG.
>
> Please, no. That would result in spamming the postmaster log
> for perfectly ordinary actions, with no usable way to prevent it.
>
>
Not sure why I was thinking it would only go to the client. You're right,
it will also go to the logs, and it will be stored by default, which would
be bad. Sorry about this...

> I think DEBUG is perfectly appropriate for this sort of message.
>
>
Still think DEBUG level is pretty bad for a user experience. Anyway, I much
prefer a DEBUG message than no message at all :)

--
Guillaume.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2025-01-08 20:48:17 Re: improve DEBUG1 logging of parallel workers for CREATE INDEX?
Previous Message Sami Imseih 2025-01-08 20:44:00 Re: improve DEBUG1 logging of parallel workers for CREATE INDEX?