Temporary tables vs unlogged tables performance in PostgreSQL?

Viewed 792

I want to know about the Temporary tables vs unlogged tables performance in PostgreSQL? I mean which is more fast for read and write operations?

1 Answers

Both are equally fast, since both bypass WAL.

The only difference is that temporary tables are cached in process private memory, governed by the temp_buffers parameter, while unlogged tables are cached in shared_buffers. So the size of these parameters will affect the performance.

Related