Re: UNLOGGED TEMPORARY tables? - Mailing list pgsql-general

From Lonni J Friedman
Subject Re: UNLOGGED TEMPORARY tables?
Date
Msg-id CAP=oouHZWWg-6dF2JTnF7RxHB7ZPMSWLkq_6HW3=vbFmVZD=nw@mail.gmail.com
Whole thread Raw
In response to UNLOGGED TEMPORARY tables?  (aasat <satriani@veranet.pl>)
Responses Re: UNLOGGED TEMPORARY tables?
List pgsql-general
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.

On Sun, Mar 24, 2013 at 1:32 PM, aasat <satriani@veranet.pl> wrote:
> I was tested write speed to temporary and unlogged tables and noticed that
> unlogged tables was a much faster
>
> Postgres 9.2.2
>
> Write speed
>
> Temporary 14.5k/s
> UNLOGGED 50k/s
>
> Before test I was convinced that temporary tables in postgres >= 9.1 are
> unlogged
>
>
>
>


pgsql-general by date:

Previous
From: News Subsystem
Date:
Subject: ...
Next
From: Guy Rouillier
Date:
Subject: Re: help me to clear postgres problem