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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
