Re: sort_mem statistics ...

On Tue, 18 Oct 2005, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> do we maintain anything anywhere for this?  mainly, some way of
>> determining # of 'sorts to disk' vs 'sort in memory', to determine whether
>> or not sort_mem is set to a good value?
>
> As of 8.1 you could turn on trace_sort to collect some data about this.
>
> 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?  Its 
not on by default, at least :)

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