On Mon, Jan 11, 2010 at 2:14 PM, Jaime Casanova <jcasanov@xxxxxxxxxxxxxxxxxxx> wrote: > On Mon, Jan 11, 2010 at 2:07 PM, Robert Haas <robertmhaas@xxxxxxxxx> wrote: >> On Mon, Jan 11, 2010 at 1:15 PM, Jaime Casanova >> <jcasanov@xxxxxxxxxxxxxxxxxxx> wrote: >>> On Sun, Sep 13, 2009 at 5:37 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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 > oh! boy this can't be happen! attaching again -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
Attachment:
log
Description: Binary data
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
