Re: Temporary, In-memory Postgres DB?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporary, In-memory Postgres DB?
Date: 2007-11-07 15:58:40
Message-ID: 17215.1194451120@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-11-07 16:04:03 Re: The .pgpass file
Previous Message rihad 2007-11-07 15:54:32 Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?