Re: Temporary Tables and Web Application

Tomasz Ostrowski wrote:
> On 2008-06-06 07:25, Brent Wood wrote:
>
>> Would "real" tables in a tablespace defined on a ramdisk meet this
>> need?
>
> Bad idea. This would mean an unusable database after a restart.

Funnily, I was thinking the same this night, somehow defining a
tablespace on tmpfs or something, so I really liked Brents suggestion.

Sadly, it seems this would have some real downsides...

>
>> You could also mount a tablespace on a physical disk with a
>> filesystem which has delayed/deferred writes to disk
>
> Not a vary good idea. This could mean an unusable database after a crash
> or power failure.
>
> Regards
> Tometzky