how do temporary tables vs unlogged tables perform in postgresql?

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.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top