James Mansion <james@xxxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
