Re: Performance of the temporary table creation and use.

From: Michael Adler <adler(at)pobox(dot)com>
To: Dann Corbit <DCorbit(at)connx(dot)com>
Cc: Luiz Gonzaga da Mata <gonzaga(at)pbh(dot)gov(dot)br>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Performance of the temporary table creation and use.
Date: 2005-01-26 04:35:44
Message-ID: 20050126043544.GA11732@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-01-26 04:38:53 Re: Patent issues and 8.1
Previous Message Neil Conway 2005-01-26 04:33:07 Re: bug w/ cursors and savepoints