Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 0D285633E52
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 11 Jan 2010 14:29:43 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 58425-02-4
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 11 Jan 2010 18:29:30 +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 5ED29635DBF
	for <pgsql-performance@postgresql.org>;
	Mon, 11 Jan 2010 14:15:37 -0400 (AST)
Received: by bwz5 with SMTP id 5so13960285bwz.3
	for <pgsql-performance@postgresql.org>;
	Mon, 11 Jan 2010 10:15:35 -0800 (PST)
MIME-Version: 1.0
Received: by 10.204.36.214 with SMTP id u22mr2804471bkd.76.1263233735405;
 Mon,
	11 Jan 2010 10:15:35 -0800 (PST)
In-Reply-To: <25315.1252881420@sss.pgh.pa.us>
References: <3073cc9b0908191745o3dc63d95q6b9308ef5bd199f2@mail.gmail.com>
	<B43373EF-4CFC-4643-AB6E-5BC0D4A7EB58@decibel.org>
	<25315.1252881420@sss.pgh.pa.us>
From: Jaime Casanova <jcasanov@systemguards.com.ec>
Date: Mon, 11 Jan 2010 13:15:20 -0500
Message-ID: <3073cc9b1001111015t3888cbbex7171d61b952218da@mail.gmail.com>
Subject: Re: [PERFORMANCE] work_mem vs temp files issue
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: decibel <decibel@decibel.org>,
	psql performance list <pgsql-performance@postgresql.org>
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=-1.859 tagged_above=-10 required=5 tests=AWL=0.740,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201001/201
X-Sequence-Number: 37081

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. =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.

--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157