Postgres Pro
Downloads
Home   >   mailing lists

Re: Temporary, In-memory Postgres DB? - Mailing list pgsql-general

From Tom Lane
Subject Re: Temporary, In-memory Postgres DB?
Date
Msg-id 17215.1194451120@sss.pgh.pa.us
Whole thread Raw
In response to Re: Temporary, In-memory Postgres DB?  (Ron Johnson <ron.l.johnson@cox.net>)
Responses DB on a ramdisk (was Re: Temporary, In-memory Postgres DB?)  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view 
Ron Johnson <ron.l.johnson@cox.net> writes:
> On 11/07/07 09:03, Gauthier, Dave wrote:
>> Is there such a thing as a temporary, probably in-memory, version of a
>> Postgres DB?

> If you have enough RAM, and your database is small enough, the OS
> will eventually cache the whole thing.

Or put it on a ramdisk filesystem.

            regards, tom lane

pgsql-general by date:

Previous
From: rihad
Date:
Subject: Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Next
From: Peter Eisentraut
Date:
Subject: Re: The .pgpass file