On Mon, Jan 11, 2010 at 2:07 PM, Robert Haas <robertmh...@gmail.com> wrote:
> On Mon, Jan 11, 2010 at 1:15 PM, Jaime Casanova
> <jcasa...@systemguards.com.ec> wrote:
>> On Sun, Sep 13, 2009 at 5:37 PM, Tom Lane <t...@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?
>

i knew i was forgotting something ;)
ah! and this is in 8.5dev but it's the same in 8.3

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to