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

From Karen Hill
Subject Re: Is there a way to run tables in RAM?
Date
Msg-id 1152826362.520022.41150@b28g2000cwb.googlegroups.com
Whole thread Raw
In response to Is there a way to run tables in RAM?  (Roy Souther <roy@silicontao.com>)
Responses Re: Is there a way to run tables in RAM?  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Roy Souther wrote:
> I would like to know if there is anyway to move a section of some tables
> into RAM to work on them.
>
> I have large table, about 700MB or so and growing. I also have a bizarre
> collection of queries that run hundreds of queries on a small section of
> this table. These queries only look at about 100 or so records at a time
> and they run hundreds of queries on the data looking for patterns. This
> causes the program to run very slowly because of hard drive access time.
> Some times it needs to write changes back to the records it is working
> with.
>
> Is there anyway that I can move a few hundred records of the table into
> RAM and work on it there, it would be much faster.
>
> 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?
>

If you are using linux, create a ramdisk and then add a Postgresql
tablespace to that.

regards,


pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: How come index isn't being used when query by function return
Next
From: Ron Johnson
Date:
Subject: Re: Is there a way to run tables in RAM?