James Mansion <[EMAIL PROTECTED]> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
