Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 1AB8D634509
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 11 Jan 2010 15:13:44 -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 26687-03-8
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 11 Jan 2010 19:13:33 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-fx0-f220.google.com (mail-fx0-f220.google.com
	[209.85.220.220])
	by mail.postgresql.org (Postfix) with ESMTP id 2498A633DD2
	for <pgsql-performance@postgresql.org>;
	Mon, 11 Jan 2010 15:07:38 -0400 (AST)
Received: by fxm20 with SMTP id 20so20997862fxm.35
	for <pgsql-performance@postgresql.org>;
	Mon, 11 Jan 2010 11:07:37 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=XFp5NVjs9+53nm4hOR05sfchFW2avOBBCYP+7UlRJAc=;
	b=IgrzhJQCKydFv/+3gfrKFzIln6Ul8nyn88ibZXKCePKNA0MRqOGioeUa/Eo0AE5V36
	K65DNKutl2oEzmdA21JRlQygoVKDp8vqA4wmVNEvxI/2WxIcg11ZLrZF2wIvUAQfNaEX
	OfNofEcjQy8XfGzrvbvgNlDfh/wgOBD1t6S1s=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=pqgw8t4JJdEFdq8eGeVpIW/ZZrRqbHs2kU+b4Ars6/T1C/uKGo5tvXRn4QncK/cc9m
	0j2ABcLCM00pDIqslLpWDVLAXNNpB3vGXCBaHXC5t1Af01DBf8KUCx4gH6vrw9g5bpyh
	/lCqn892YshVnB1mA0SVfnjAqRfWEX8/MWkpI=
MIME-Version: 1.0
Received: by 10.239.139.39 with SMTP id r39mr1543760hbr.116.1263236857242;
	Mon, 11 Jan 2010 11:07:37 -0800 (PST)
In-Reply-To: <3073cc9b1001111015t3888cbbex7171d61b952218da@mail.gmail.com>
References: <3073cc9b0908191745o3dc63d95q6b9308ef5bd199f2@mail.gmail.com>
	<B43373EF-4CFC-4643-AB6E-5BC0D4A7EB58@decibel.org>
	<25315.1252881420@sss.pgh.pa.us>
	<3073cc9b1001111015t3888cbbex7171d61b952218da@mail.gmail.com>
Date: Mon, 11 Jan 2010 14:07:37 -0500
Message-ID: <603c8f071001111107v75276375g4d626dfc0efd8dc4@mail.gmail.com>
Subject: Re: [PERFORMANCE] work_mem vs temp files issue
From: Robert Haas <robertmhaas@gmail.com>
To: Jaime Casanova <jcasanov@systemguards.com.ec>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, decibel <decibel@decibel.org>,
	psql performance list <pgsql-performance@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
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/205
X-Sequence-Number: 37085

On Mon, Jan 11, 2010 at 1:15 PM, Jaime Casanova
<jcasanov@systemguards.com.ec> wrote:
> On Sun, Sep 13, 2009 at 5:37 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> It might be useful to turn on trace_sort to see if the small files
>> are coming from sorts. =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?

...Robert