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>