Re: temp tables

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

James Mansion <james(at)mansionfamily(dot)plus(dot)com> writes:
> Do CREATE TEMP TABLE table have any special treatment regarding eliding 
> sync operations

Yes; neither fsync nor WAL-writing is done for temp tables.

> or deferring creation of disk files in the case where memory pressure 
> does not require a spill?

No.  The trouble with doing something like that is we might be forced to
report an out-of-disk-space failure at some quite unintuitive point,
like during a SELECT.

			regards, tom lane