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

From Ron Johnson
Subject Re: Temporary, In-memory Postgres DB?
Date
Msg-id 4731D700.1070101@cox.net
Whole thread Raw
In response to Temporary, In-memory Postgres DB?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: Temporary, In-memory Postgres DB?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Re: Temporary, In-memory Postgres DB?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 11/07/07 09:03, Gauthier, Dave wrote:
> This is a real longshot, but here goes...
>
>
>
> Is there such a thing as a temporary, probably in-memory, version of a
> Postgres DB?  Sort of like SQLite, only with the features/function of
> PG?  A DB like this would exist inside of, and for the duration of, a
> script/program that created it, then vanish when the script/program
> ends.
>
>
>
> Probably not, but if not, then this would be (IMO) a great addition to
> have, something that'd really make it distinct from MySQL .  I'd use
> SQLite, but I want to have stored functions and other "real" database
> features that it just doesn't have.

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

I know that's not exactly what you're talking about, but I think
it's as close as you'll get.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHMdcAS9HxQb37XmcRAqD9AJ4usfOq49ApqnLOz9advUnRmc7q2QCdFa8s
xAL+tMf4Xu4T4hGhvUCzomA=
=QmE5
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: prepared statements suboptimal?
Next
From: Tom Lane
Date:
Subject: Re: any way for ORDER BY x to imply NULLS FIRST in 8.3?