Re: UNLOGGED TEMPORARY tables?

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Lonni J Friedman <netllama(at)gmail(dot)com>
Cc: aasat <satriani(at)veranet(dot)pl>, pgsql-general(at)postgresql(dot)org
Subject: Re: UNLOGGED TEMPORARY tables?
Date: 2013-03-25 23:49:09
Message-ID: CAB7nPqTkZvESuZ3qcN_Tj82qY6_YERW1iZTMGLZ+qyscZCM4Uw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 26, 2013 at 8:26 AM, Lonni J Friedman <netllama(at)gmail(dot)com>wrote:

> I'm pretty sure that unlogged tables and temp tables are two separate
> & distinct features, with no overlap in functionality. It would be
> nice if it was possible to create an unlogged temp table.
>
Temporary tables are a subtype of unlogged tables, as temporary tables are
not WAL-logged.
This article from Robert Haas will give a good summary of such differences:
http://rhaas.blogspot.jp/2010/05/global-temporary-and-unlogged-tables.html
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2013-03-26 00:40:22 Re: UNLOGGED TEMPORARY tables?
Previous Message Tom Lane 2013-03-25 23:44:01 Re: UNLOGGED TEMPORARY tables?