Re: Is there a way to run tables in RAM?

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Is there a way to run tables in RAM?
Дата
Msg-id 44B6964D.5070906@commandprompt.com
обсуждение исходный текст
Ответ на Is there a way to run tables in RAM?  (Roy Souther <roy@silicontao.com>)
Список pgsql-general
> Is there anyway to create a temporary table that will only exist in RAM
> and not be written to the hard drive? Or do temporary tables already do
> that?

That is what temp tables do... but you should only use them for
throwaway data :)

Joshua D. Drake


>
> If I can use a temporary table this way is there any simple way to merge
> the changes back into the original table?
>
> _Royce Souther <mailto:roy@SiliconTao.com>_
> _www.SiliconTao.com <http://www.SiliconTao.com>_
> Let Open Source help your business move beyond.
>
> For security this message is digitally authenticated by _GnuPG
> <http://www.gnupg.org>_.
>
>
>
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Bowlby
Дата:
Сообщение: SPI based table locks.
Следующее
От: "Sergio Duran"
Дата:
Сообщение: I need help creating a query