Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 8B5EA15A7DE1
	for <pgsql-performance@postgresql.org>;
	Fri, 13 Apr 2012 13:36:31 -0300 (ADT)
Received: from cerberus.pinpointresearch.com ([66.7.238.130]
	helo=polaris.pinpointresearch.com)
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <scrawford@pinpointresearch.com>) id 1SIjU6-0005la-7H
	for pgsql-performance@postgresql.org; Fri, 13 Apr 2012 16:36:31 +0000
Received: from betelgeuse.pinpointresearch.com
	(betelgeuse.pinpointresearch.com [192.168.1.179])
	by polaris.pinpointresearch.com (Postfix) with ESMTP id 3C8BBE00EC84;
	Fri, 13 Apr 2012 09:36:17 -0700 (PDT)
Message-ID: <4F885604.6080404@pinpointresearch.com>
Date: Fri, 13 Apr 2012 09:36:20 -0700
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19
MIME-Version: 1.0
To: Claudio Freire <klaussfreire@gmail.com>
CC: Eyal Wilde <eyal@impactsoft.co.il>, pgsql-performance@postgresql.org
Subject: Re: scale up (postgresql vs mssql)
References: 
 <CAMiEbcj+6ViLiAX0C3+VzhVGt5ZedMh8KCE1JTgXgEVUq+GeNw@mail.gmail.com>
	<CAGTBQpYga9Uo4n=qUPyYOkuzW+2MoDYoRnBF53jvb546=Hbbqg@mail.gmail.com>
In-Reply-To: 
 <CAGTBQpYga9Uo4n=qUPyYOkuzW+2MoDYoRnBF53jvb546=Hbbqg@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201204/104
X-Sequence-Number: 46750

On 04/13/2012 08:04 AM, Claudio Freire wrote:
> ...You might want to try unlogged temp tables, which more
> closely resemble mssql temp tables.
>
If they are permanent tables used for temporary storage then making them 
unlogged may be beneficial. But actual temporary tables *are* unlogged 
and attempting to create an unlogged temporary table will raise an error.

Cheers,
Steve