pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
temp tables 2+ messages / 2 participants [nested] [flat]
* temp tables @ 2008-03-13 22:08 James Mansion <james@mansionfamily.plus.com> 0 siblings, 1 reply; 2+ messages in thread From: James Mansion @ 2008-03-13 22:08 UTC (permalink / raw) To: pgsql-performance Do CREATE TEMP TABLE table have any special treatment regarding eliding sync operations or deferring creation of disk files in the case where memory pressure does not require a spill? James ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: temp tables @ 2008-03-14 00:01 Tom Lane <tgl@sss.pgh.pa.us> parent: James Mansion <james@mansionfamily.plus.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2008-03-14 00:01 UTC (permalink / raw) To: James Mansion <james@mansionfamily.plus.com>; +Cc: pgsql-performance James Mansion <james@mansionfamily.plus.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-03-14 00:01 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-03-13 22:08 temp tables James Mansion <james@mansionfamily.plus.com> 2008-03-14 00:01 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox