Re: Temporary Tables and Web Application - Mailing list pgsql-general

From Tim Tassonis
Subject Re: Temporary Tables and Web Application
Date
Msg-id 484912FD.10604@cubic.ch
Whole thread Raw
In response to Re: Temporary Tables and Web Application  (Tomasz Ostrowski <tometzky@batory.org.pl>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Hermann Muster
Date:
Subject: Re: Accessing other databases with DBLink when leaving user/password empty
Next
From: Viktor Rosenfeld
Date:
Subject: Questions about index usage