| From: | Tim Tassonis <timtas(at)cubic(dot)ch> |
|---|---|
| To: | Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Temporary Tables and Web Application |
| Date: | 2008-06-06 10:35:41 |
| Message-ID: | 484912FD.10604@cubic.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2008-06-06 12:12:18 | Re: Annoying messages when copy sql code to psql terminal |
| Previous Message | Viktor Rosenfeld | 2008-06-06 10:35:22 | Questions about index usage |