UNLOGGED TEMPORARY tables?

From: aasat <satriani(at)veranet(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: UNLOGGED TEMPORARY tables?
Date: 2013-03-24 20:32:54
Message-ID: 1364157174420-5749477.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
View this message in context: http://postgresql.1045698.n5.nabble.com/UNLOGGED-TEMPORARY-tables-tp5749477.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Zegelin 2013-03-25 00:25:44 Re: Enforcing Parameterised Nested Loop Join Order for Foreign Table Joins
Previous Message Aleksey Tsalolikhin 2013-03-24 20:05:41 Re: Need advice on best system to choose