From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: sort_mem statistics ... |
Date: | 2005-10-18 22:28:01 |
Message-ID: | 20051018192722.M995@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 18 Oct 2005, Tom Lane wrote:
> "Marc G. Fournier" <scrappy(at)postgresql(dot)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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-10-18 22:29:56 | Re: Question about Ctrl-C and less |
Previous Message | Kevin Grittner | 2005-10-18 22:15:20 | Re: Question about Ctrl-C and less |