| Lists: | pgsql-hackers |
|---|
| From: | "Steve Yalovitser" <yalo(at)integrasoftware(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Question regarding coopting Database Engine |
| Date: | 2003-09-30 04:10:57 |
| Message-ID: | IEEMJHGBPDGDPPENJFGCCEOMFHAA.yalo@integrasoftware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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...
| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Steve Yalovitser <yalo(at)integrasoftware(dot)com> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Question regarding coopting Database Engine |
| Date: | 2003-10-03 15:44:42 |
| Message-ID: | 1065195881.24240.46.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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?
| From: | Hans-Jürgen Schönig <hs(at)cybertec(dot)at> |
|---|---|
| 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-05 13:41:07 |
| Message-ID: | 3F801F73.4000900@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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(at)postgresql(dot)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