Re: [PERFORM] The need for clustered indexes to boost TPC-V performance

Craig Ringer <ringerc@xxxxxxxxxxxxx> · Fri, 06 Jul 2012 11:02:34 +0800



    On 07/06/2012 09:33 AM, Samuel Gendler
      wrote:

    
        Some other potential issues - with only 10MB of work_mem,
          you might be gong to temp space on disk more than you realize.
           Explain analyze might reveal that, but only if you happen to
          pick a query that exceeds work_mem on at least one step.
      
    
    Rather than hunting blindly with EXPLAIN ANALYZE it's better to just
    turn log_temp_files on and see what's reported.

    
    --

    Craig Ringer