Temporary tables and Write-Ahead Log

Started by Víctor Herraiz Posada7 days ago3 messagesdocs
Jump to latest
#1Víctor Herraiz Posada
victor.herraiz@gmail.com

In create table documentation is not clear if temporary tables use the write-ahead log. Could you please add a sentence about that like in the unlogged tables?

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: Víctor Herraiz Posada (#1)
Re: Temporary tables and Write-Ahead Log

On Friday, April 17, 2026, Víctor Herraiz Posada <victor.herraiz@gmail.com>
wrote:

In create table documentation is not clear if temporary tables use the
write-ahead log. Could you please add a sentence about that like in the
unlogged tables?

The word “temporary” is communicating the entire first paragraph of what we
spell out in unlogged.

However, maybe I’d add to the end:

“Aside from the above, a temporary table behaves much like an unlogged
table - though a partitioned table consisting solely of temporary
partitions is allowed.”

David J.

#3Víctor Herraiz Posada
victor.herraiz@gmail.com
In reply to: David G. Johnston (#2)
Re: Temporary tables and Write-Ahead Log