Skip site navigation (1) Skip section navigation (2)

Re: Question regarding coopting Database Engine

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Steve Yalovitser <yalo(at)integrasoftware(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Question regarding coopting Database Engine
Date: 2003-10-03 15:24:18
Message-ID: Pine.LNX.4.33.0310030923240.27107-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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...


In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-10-03 15:34:04
Subject: Re: Using backslash in query
Previous:From: Andrew SullivanDate: 2003-10-03 15:17:15
Subject: Re: Thoughts on maintaining 7.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group