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

From Marc G. Fournier
Subject Re: sort_mem statistics ...
Date
Msg-id 20051018200648.A995@ganymede.hub.org
Whole thread Raw
In response to sort_mem statistics ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-hackers
On Tue, 18 Oct 2005, Tom Lane wrote:

> "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 ...

Oops, sorry, I was thinking in terms of syslog log levels ... :(

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Seeing context switch storm with 10/13 snapshot of
Next
From: Tom Lane
Date:
Subject: Re: sort_mem statistics ...