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

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: roy(at)silicontao(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a way to run tables in RAM?
Date: 2006-07-13 18:51:57
Message-ID: 44B6964D.5070906@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)SiliconTao(dot)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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sergio Duran 2006-07-13 19:20:20 I need help creating a query
Previous Message Martijn van Oosterhout 2006-07-13 18:39:53 Re: Is there a way to run tables in RAM?