Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id F047A63381E
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 13 Jan 2010 10:45:36 -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 91806-06
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 13 Jan 2010 14:45:17 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id 410C16335CF
	for <pgsql-performance@postgresql.org>;
	Wed, 13 Jan 2010 10:45:26 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o0DEjCif010186;
	Wed, 13 Jan 2010 09:45:12 -0500 (EST)
To: Jaime Casanova <jcasanov@systemguards.com.ec>
cc: Robert Haas <robertmhaas@gmail.com>, decibel <decibel@decibel.org>,
	psql performance list <pgsql-performance@postgresql.org>
Subject: Re: [PERFORMANCE] work_mem vs temp files issue 
In-reply-to: <3073cc9b1001122231m1a15d187lae2a8096a813361b@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>
	<603c8f071001111107v75276375g4d626dfc0efd8dc4@mail.gmail.com>
	<3073cc9b1001111114j7ddacd56p8966f9d61997a8b@mail.gmail.com>
	<3073cc9b1001111116x53427c9bm1e448128a3b4f6c6@mail.gmail.com>
	<18803.1263241120@sss.pgh.pa.us>
	<3073cc9b1001122231m1a15d187lae2a8096a813361b@mail.gmail.com>
Comments: In-reply-to Jaime Casanova <jcasanov@systemguards.com.ec>
	message dated "Wed, 13 Jan 2010 01:31:43 -0500"
Date: Wed, 13 Jan 2010 09:45:11 -0500
Message-ID: <10185.1263393911@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.458 tagged_above=-10 required=5 tests=AWL=0.141,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201001/248
X-Sequence-Number: 37128

Jaime Casanova <jcasanov@systemguards.com.ec> writes:
> why we don't show some of that info in explain?

Lack of round tuits; plus concern about breaking programs that read
EXPLAIN output, which I guess will be alleviated in 8.5.

> the reason i say "most of the temp files" is that when i removed
> #ifdef HJDEBUG it says that in total i was using 10 batchs but there
> were 14 temp files created (i guess we use 1 file per batch, no?)

Two files per batch, in general --- I suppose some of the buckets
were empty.

			regards, tom lane