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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings