Skip site navigation (1) Skip section navigation (2)

Re: temp tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Mansion <james(at)mansionfamily(dot)plus(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: temp tables
Date: 2008-03-14 00:01:45
Message-ID: 27663.1205452905@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

  • temp tables at 2008-03-13 22:08:39 from James Mansion

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-03-14 05:53:41
Subject: Re: Recomendations on raid controllers raid 1+0
Previous:From: Leigh DyerDate: 2008-03-13 23:14:46
Subject: Re: Recomendations on raid controllers raid 1+0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group