| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, decibel <decibel(at)decibel(dot)org>, psql performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: [PERFORMANCE] work_mem vs temp files issue |
| Date: | 2010-01-11 19:07:37 |
| Message-ID: | 603c8f071001111107v75276375g4d626dfc0efd8dc4@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Jan 11, 2010 at 1:15 PM, Jaime Casanova
<jcasanov(at)systemguards(dot)com(dot)ec> wrote:
> On Sun, Sep 13, 2009 at 5:37 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2010-01-11 19:14:52 | Re: [PERFORMANCE] work_mem vs temp files issue |
| Previous Message | Bob Dusek | 2010-01-11 18:57:31 | Re: performance config help |