Re: sort_mem statistics ...

Tom,

Tom Lane wrote:
>>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.

Why is the trace_sort option DEVELOPER_OPTIONS?

I think the sort statistics are *very* important for DBAs,
not only for developers (hackers).

Without any numerical evidence, trying (and error) to fitwork_mem value
will be painfull and wasting DBA's time.

And I want to get statistic info through system views, like pg_statio_*.

Please remember my previous post.
http://archives.postgresql.org/pgsql-patches/2005-09/msg00116.php

-- 
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>