Postgres Pro
Downloads
Home   >   mailing lists

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

From aasat
Subject Re: UNLOGGED TEMPORARY tables?
Date
Msg-id 1364284459014-5749662.post@n5.nabble.com
Whole thread Raw
In response to UNLOGGED TEMPORARY tables?  (aasat <satriani@veranet.pl>)
List pgsql-general
Tree view 
New test with temporary table and unlogged

Total rows 600k
Table size after copy 121MB

temp_buffers / copy speed

16MB - 12999 rows/s
128MB - 13005 rows/s
256MB - 13258 rows/s
512MB - 13399 rows/s
1GB -  13145 rows/s

Unlogged table - 13333 rows/s

I don't undestand why previous test showed the difference



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

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Money casting too liberal?
Next
From: aasat
Date:
Subject: Re: UNLOGGED TEMPORARY tables?