Postgres Pro
Downloads
Home   >   mailing lists

UNLOGGED TEMPORARY tables? - Mailing list pgsql-general

From aasat
Subject UNLOGGED TEMPORARY tables?
Date
Msg-id 1364157174420-5749477.post@n5.nabble.com
Whole thread Raw
Responses Re: UNLOGGED TEMPORARY tables?  (Lonni J Friedman <netllama@gmail.com>)
Re: UNLOGGED TEMPORARY tables?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: jayaram s
Date:
Subject: help me to clear postgres problem
Next
From: Denver Timothy
Date:
Subject: Re: PostgreSQL EXCLUDE USING error: Data type integer has no default operator class