Re: sort_mem statistics ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: sort_mem statistics ...
Date: 2005-10-18 22:57:16
Message-ID: 14977.1129676236@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Marc G. Fournier" <scrappy(at)postgresql(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-10-18 23:07:05 Re: sort_mem statistics ...
Previous Message Andrew Dunstan 2005-10-18 22:36:45 Re: 2nd try @NetBSD/2.0 Alpha