Re: Is there a way to run tables in RAM? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Is there a way to run tables in RAM?
Date
Msg-id 44B6964D.5070906@commandprompt.com
Whole thread Raw
In response to Is there a way to run tables in RAM?  (Roy Souther <roy@silicontao.com>)
List 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 by date:

Previous
From: Chris Bowlby
Date:
Subject: SPI based table locks.
Next
From: "Sergio Duran"
Date:
Subject: I need help creating a query