Re: UNLOGGED TEMPORARY tables?

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

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bartosz Dmytrak 2013-03-26 08:35:19 effective_io_concurrency on Windows
Previous Message dinesh kumar 2013-03-26 07:35:38 Re: help me to clear postgres problem