Re: Temporary tables and Write-Ahead Log

Thank you David. I would be great to have that in the documents. I saw several “opinions” across internet.

El 18 abr 2026, a las 9:01, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> escribió:

On Friday, April 17, 2026, Víctor Herraiz Posada <victor(dot)herraiz(at)gmail(dot)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.