Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id A598B2E38AE
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 13 Mar 2008 19:17:54 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 95293-02-4
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 13 Mar 2008 19:17:46 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132])
	by postgresql.org (Postfix) with ESMTP id 21E3D2E31C8
	for <pgsql-performance@postgresql.org>;
	Thu, 13 Mar 2008 19:05:04 -0300 (ADT)
Received: from [80.229.150.39] (helo=mansionfamily.plus.com)
	by pih-relay05.plus.net with esmtp (Exim) id 1JZvXo-00081q-L2
	for pgsql-performance@postgresql.org; Thu, 13 Mar 2008 22:05:01 +0000
Received: from [192.168.0.87] ([192.168.0.87]:3272)
	by mansionfamily.plus.com with [XMail 1.22 ESMTP Server]
	id <S138BE> for <pgsql-performance@postgresql.org> from
	<james@mansionfamily.plus.com>; Thu, 13 Mar 2008 22:09:31 -0000
Message-ID: <47D9A5E7.1010802@mansionfamily.plus.com>
Date: Thu, 13 Mar 2008 22:08:39 +0000
From: James Mansion <james@mansionfamily.plus.com>
Organization: MsgWare
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: temp tables
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Plusnet-Relay: eeed8ae041193756a9362265799b7be8
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/291
X-Sequence-Number: 29245

Do CREATE TEMP TABLE table have any special treatment regarding eliding 
sync operations
or deferring creation of disk files in the case where memory pressure 
does not require a spill?

James