Re: UNLOGGED TEMPORARY tables?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: aasat <satriani(at)veranet(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UNLOGGED TEMPORARY tables?
Date: 2013-03-25 23:26:24
Message-ID: CAP=oouHZWWg-6dF2JTnF7RxHB7ZPMSWLkq_6HW3=vbFmVZD=nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)veranet(dot)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
>
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2013-03-25 23:41:31 Re: help me to clear postgres problem
Previous Message CR Lender 2013-03-25 23:16:50 pg_stat_get_last_vacuum_time(): why non-FULL?