Re: UNLOGGED TEMPORARY tables?

aasat <satriani(at)veranet(dot)pl> writes:
> 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

I think there's something skewed about your test.

Temp tables *are* unlogged. They also live in session-private buffers,
which eliminates a great deal of synchronization overhead; at the cost
that any writing that does happen has to be done by the backend process
itself, without help from the background writer. It's possible that
there's something about your specific test case that makes that scenario
look bad. Another likely source of bogus results is if you were testing
a tiny temp_buffers setting versus a more appropriately sized
shared_buffers setting.

However, this is all speculation, since you provided not a whit of
detail about your test case. Nobody's going to take these numbers
seriously if you haven't explained how to reproduce them.

regards, tom lane