Re: Performance of the temporary table creation and use. - Mailing list pgsql-hackers

From Michael Adler
Subject Re: Performance of the temporary table creation and use.
Date
Msg-id 20050126043544.GA11732@pobox.com
Whole thread Raw
In response to Re: Performance of the temporary table creation and use.  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
On Tue, Jan 25, 2005 at 03:29:55PM -0800, Dann Corbit wrote:
> If you store the temp tables in RAM, how will you preserve the ACID
> property on power failure (without using write-through which would
> negate the speed advantage)?
> 
> The temp tables may be participating in a transaction.

Temp tables are only visible inside a single session. They are
inherently not durable. 
-Mike Adler


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: bug w/ cursors and savepoints
Next
From: Neil Conway
Date:
Subject: Re: Patent issues and 8.1