Thread: Question regarding coopting Database Engine

Question regarding coopting Database Engine

From
"Steve Yalovitser"
Date:
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



Re: Question regarding coopting Database Engine

From
"scott.marlowe"
Date:
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...



Re: Question regarding coopting Database Engine

From
Rod Taylor
Date:
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?

Re: Question regarding coopting Database Engine

From
"Gottfried F. Zojer"
Date:
Hi Steve ,

I m interested on similar things but I m too new to PostgreSQL  to give any hint .
My first approach is to compile with a different compiler to get a idea of the system.

Best regards

Gottfried  



"Steve Yalovitser" <yalo@integrasoftware.com> schrieb am 03.10.03 17:29:16:
> 
> 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





Re: Question regarding coopting Database Engine

From
Hans-Jürgen Schönig
Date:
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