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

From: "Merlin Moncure" <mmoncure(at)gmail(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 20:15:08
Message-ID: b42b73150607131315x2bb922b2gb89bbb62fdf3f962@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/13/06, Roy Souther <roy(at)silicontao(dot)com> wrote:
>
>
> I would like to know if there is anyway to move a section of some tables into RAM to work on them.

the operating system should cache the table if there is memory
available. while disk cache is somewhat slower than raw memory read,
now you have memory for lots of other things, like sorting.

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message lanczos 2006-07-13 20:40:29 Re: =???UTF-8?Q?re: How to insert .xls...
Previous Message Richard Broersma Jr 2006-07-13 19:44:44 Re: I need help creating a query