Hello,

I'd like to know if its possible to coopt the postgres storage subsystem to
rely entirely on ram based structures, rather than disk. Any documentation
or ideas would be appreciated.

Cheers,

Steve


Tue, 30 Sep 2003 00:10:57 -0400
"Steve Yalovitser" <yalo@integrasoftware.com>
Question regarding coopting Database Engine
On Tue, 30 Sep 2003, Steve Yalovitser wrote:

> Hello,
> 
> I'd like to know if its possible to coopt the postgres storage subsystem to
> rely entirely on ram based structures, rather than disk. Any documentation
> or ideas would be appreciated.

Sure, create a ram disk.  Set $PGDATA to it with proper permissions, 
initdb, and restore.

Not sure why'd you wanna do it, as any crash loses all data, and 
postgresql's strengths lie in its ability to survive the most brutal power 
off situations mid-transaction etc...


Fri, 3 Oct 2003 09:24:18 -0600 (MDT)
"scott.marlowe" <scott.marlowe@ihs.com>
Re: Question regarding coopting Database Engine
On Tue, 2003-09-30 at 00:10, Steve Yalovitser wrote:
> Hello,
> 
> I'd like to know if its possible to coopt the postgres storage subsystem to
> rely entirely on ram based structures, rather than disk. Any documentation
> or ideas would be appreciated.

Just so you know, this isn't going to make the system any faster.

I assume you are trying to do something like put the database onto a
bootable CD that fires up some static application with static
information?
Fri, 03 Oct 2003 11:44:42 -0400
Rod Taylor <rbt@rbt.ca>
Re: Question regarding coopting Database Engine
Steve Yalovitser wrote:
> Hello,
> 
> I'd like to know if its possible to coopt the postgres storage subsystem to
> rely entirely on ram based structures, rather than disk. Any documentation
> or ideas would be appreciated.
> 
> Cheers,
> 
> Steve
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 


Why don't you just define a RAM disk and run PostgreSQL on it? ;)

	Hans

-- 
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706 or +43/660/816 40 77
www.cybertec.at, www.postgresql.at, kernel.cybertec.at



Sun, 05 Oct 2003 15:41:07 +0200
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <hs@cybertec.at>
Re: Question regarding coopting Database Engine