Re: sort_mem statistics ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: sort_mem statistics ...
Date
Msg-id 14977.1129676236@sss.pgh.pa.us
Whole thread Raw
In response to sort_mem statistics ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: sort_mem statistics ...
Re: sort_mem statistics ...
List pgsql-hackers
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> On Tue, 18 Oct 2005, Tom Lane wrote:
>> Looking at the code, I notice that the messages are all emitted at level 
>> NOTICE.  Perhaps that was not such a good idea --- it'd be pretty much 
>> in-your-face if it were on all the time.  Does anyone think it'd be a 
>> good idea to emit the trace_sort messages at level LOG, instead?

> If someone sets trace_sort, does it matter what level its emit'd at?

Well, yeah.  It depends whether you are thinking of the trace feature as
being used interactively, or as something turned on to gather data over
time in a production installation.  In the second case you'd want the
info to go to the postmaster log, but not want to see it dumped on your
terminal all the time ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: sort_mem statistics ...
Next
From: Andrew Dunstan
Date:
Subject: Re: 2nd try @NetBSD/2.0 Alpha