Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3452B63441D for ; Mon, 11 Jan 2010 15:36:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31636-01-7 for ; Mon, 11 Jan 2010 19:36:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com [209.85.218.213]) by mail.postgresql.org (Postfix) with ESMTP id 3B87F633DDA for ; Mon, 11 Jan 2010 15:15:08 -0400 (AST) Received: by bwz5 with SMTP id 5so14016821bwz.3 for ; Mon, 11 Jan 2010 11:15:07 -0800 (PST) MIME-Version: 1.0 Received: by 10.204.36.214 with SMTP id u22mr2844508bkd.76.1263237307469; Mon, 11 Jan 2010 11:15:07 -0800 (PST) In-Reply-To: <603c8f071001111107v75276375g4d626dfc0efd8dc4@mail.gmail.com> References: <3073cc9b0908191745o3dc63d95q6b9308ef5bd199f2@mail.gmail.com> <25315.1252881420@sss.pgh.pa.us> <3073cc9b1001111015t3888cbbex7171d61b952218da@mail.gmail.com> <603c8f071001111107v75276375g4d626dfc0efd8dc4@mail.gmail.com> From: Jaime Casanova Date: Mon, 11 Jan 2010 14:14:52 -0500 Message-ID: <3073cc9b1001111114j7ddacd56p8966f9d61997a8b@mail.gmail.com> Subject: Re: [PERFORMANCE] work_mem vs temp files issue To: Robert Haas Cc: Tom Lane , decibel , psql performance list Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.589 tagged_above=-10 required=5 tests=BAYES_00=-2.599, FH_DATE_PAST_20XX=3.188 X-Spam-Level: X-Archive-Number: 201001/206 X-Sequence-Number: 37086 On Mon, Jan 11, 2010 at 2:07 PM, Robert Haas wrote: > On Mon, Jan 11, 2010 at 1:15 PM, Jaime Casanova > wrote: >> On Sun, Sep 13, 2009 at 5:37 PM, Tom Lane wrote: >>> >>> It might be useful to turn on trace_sort to see if the small files >>> are coming from sorts. =C2=A0If 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 --=20 Atentamente, Jaime Casanova Soporte y capacitaci=C3=B3n de PostgreSQL Asesor=C3=ADa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157