Thread

1. Question regarding coopting Database Engine

   Steve Yalovitser <yalo@integrasoftware.com> — 2003-09-30T04:10:57Z

   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
   
   
   

2. Re: Question regarding coopting Database Engine

   scott.marlowe <scott.marlowe@ihs.com> — 2003-10-03T15:24:18Z

   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...
   
   
   

3. Re: Question regarding coopting Database Engine

   Rod Taylor <rbt@rbt.ca> — 2003-10-03T15:44:42Z

   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?
   

4. Re: Question regarding coopting Database Engine

   Hans-Jürgen Schönig <hs@cybertec.at> — 2003-10-05T13:41:07Z

   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