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.