Re: Temporary Tables and Web Application

Поиск
Список
Период
Сортировка
От Tim Tassonis
Тема Re: Temporary Tables and Web Application
Дата
Msg-id 484912FD.10604@cubic.ch
обсуждение исходный текст
Ответ на Re: Temporary Tables and Web Application  (Tomasz Ostrowski <tometzky@batory.org.pl>)
Список 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 по дате отправления:

Предыдущее
От: Hermann Muster
Дата:
Сообщение: Re: Accessing other databases with DBLink when leaving user/password empty
Следующее
От: Viktor Rosenfeld
Дата:
Сообщение: Questions about index usage