The idea of a RAM disk based database and reliable storage are in
complete opposition. Forget it.
The question is: What do you need the *raw* speed of a RAM disk for, and
what can you tollerate for overhead for reliability?
You have posed a question about how to implement a flawed solution, what
is the original problem you are intending to solve?
Chris Sutton wrote:
>I need some insight on the best way to use a RAM drive in a Postgresql
>installation. Here is our situation and current setup:
>Dual PIII 800
>RAID 5 SCSI disks
>Platypus 8GB PCI QikDrive (the RAM drive). http://www.platypus.net
>The Platypus RAM drive is a PCI card with 8GB of ram onboard with an
>external power supply so if the main power to the server goes off, the RAM
>is still powered, so it's persistent between reboots.
>Currently the disk size of our database is 3.2GB, so we put the whole
>pgsql directory on the RAM drive. Current preformance is very
>snappy with the bottleneck being the CPUs.
>The concern of course is if something happends to the RAM drive we are
>S.O.L. and have to go to the last backup (pg_dump happens each night).
>The other concern is if the disk size of the database grows past or near
>8gb, we would either have to get a bigger RAM drive or somehow split
>things betten SCSI and RAM drive.
>I don't quite grasp the full inner workings of Postgresql, but
>for those of you who obviously do, is there a better way of setting things
>up where you could still use the RAM drive for portions of the pgsql
>directory structure while putting the rest on disk where it's safer?
>Should we just put pgsql/data/pg_xlog on the RAM drive?
>Also, in the very near future we will be upgrading to another server,
>pg7.3.2 with dual P4 2.4 xenon's. The RAM drive will go into this new
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
In response to
pgsql-hackers by date
|Next:||From: mlw||Date: 2003-03-05 20:47:18|
|Subject: Aggregate "rollup"|
|Previous:||From: Bruce Momjian||Date: 2003-03-05 20:04:04|
|Subject: Re: [PATCHES] Non-colliding auto generated names|