Temporary tables vs unlogged tables performance in PostgreSQL?

Question

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?

Laurenz Albe · Accepted Answer · 2020-11-05 11:50:28Z

12

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.

answered Nov 5, 2020 at 11:50

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ali Hussain Over a year ago

what is difference in size of these buffers?

Laurenz Albe Over a year ago

You can set them however you want, so you can determine the difference.

Collectives™ on Stack Overflow

Temporary tables vs unlogged tables performance in PostgreSQL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related