Re: [PERFORMANCE] work_mem vs temp files issue - Mailing list pgsql-performance

From Robert Haas
Subject Re: [PERFORMANCE] work_mem vs temp files issue
Date
Msg-id 603c8f071001111107v75276375g4d626dfc0efd8dc4@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORMANCE] work_mem vs temp files issue  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: [PERFORMANCE] work_mem vs temp files issue  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-performance
On Mon, Jan 11, 2010 at 1:15 PM, Jaime Casanova
<jcasanov@systemguards.com.ec> wrote:
> On Sun, Sep 13, 2009 at 5:37 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> It might be useful to turn on trace_sort to see if the small files
>> are coming from sorts.  If they're from hashes I'm afraid there's
>> no handy instrumentation ...
>>
>
> yes they are, this is the log (i deleted the STATEMENT lines because
> they were redundant), seems like all the temp files are used to
> execute the same sentence...
>
> BTW, this is my laptop no the server.

I think maybe there was supposed to be an attachment here?

...Robert

pgsql-performance by date:

Previous
From: Bob Dusek
Date:
Subject: Re: performance config help
Next
From: Jaime Casanova
Date:
Subject: Re: [PERFORMANCE] work_mem vs temp files issue