| From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(dot)paquier(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-26 00:40:22 |
| Message-ID: | CAP=oouFGoU=FK+WqD+zZt0e1xi4-DHsX=aXj3ffuPOAY_64=Nw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Mar 25, 2013 at 4:49 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:
>
>
> 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
Thanks, that's good to know. the official dox don't really make it
clear that temp tables are unlogged.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Misa Simic | 2013-03-26 00:48:03 | Re: PostgreSQL and VIEWS |
| Previous Message | Michael Paquier | 2013-03-25 23:49:09 | Re: UNLOGGED TEMPORARY tables? |