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? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
