The platypus model he has has an external PSU. The external PSU can be
easily plugged into an UPS. Thus if the main system is shut down as long
as the UPS lives and/or there is power otherwise to the external PSU, the
card will keep the data.
--On Thursday, March 06, 2003 11:16 PM +0200 Hannu
mlw kirjutas K, 05.03.2003 kell 22:05:
> The idea of a RAM disk based database and reliable storage are in
> complete opposition. Forget it.
I read from his post that the Platypus RAM disk _is_ his reliable
storage, just with some peculiar characteristics, like big transfer
speeds and uniform sup
Hannu Krosing kirjutas T, 04.03.2003 kell 22:57:
> Chris Sutton kirjutas T, 04.03.2003 kell 17:03:
> > Hello,
> >
> > I need some insight on the best way to use a RAM drive in a Postgresql
> > installation. Here is our situation and current setup:
> >
> > Postgresql 7.2.1
> > Dual PIII 800
> >
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, wha
Chris,
> 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).
This is the drawback to RAM drives, period. If there was some way to use a
RAM drive without risking your data, everyone would do it (or at l
asking for trouble! (At least until we have point in time recovery, but
that still requires you to have your xlog on hard drive)
Chris
- Original Message -
From: "Chris Sutton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 04, 2003 11:03 PM
Subject
On Tue, 4 Mar 2003, Chris Sutton wrote:
> Hello,
>
> I need some insight on the best way to use a RAM drive in a Postgresql
> installation. Here is our situation and current setup:
>
> Postgresql 7.2.1
First suggestion: upgrade to 7.2.4 to address several bugs.
> The concern of course is if
Chris Sutton kirjutas T, 04.03.2003 kell 17:03:
> Hello,
>
> I need some insight on the best way to use a RAM drive in a Postgresql
> installation. Here is our situation and current setup:
>
> Postgresql 7.2.1
> Dual PIII 800
> RAID 5 SCSI disks
> Platypus 8GB PCI QikDrive (the RAM drive). htt
Hello,
I need some insight on the best way to use a RAM drive in a Postgresql
installation. Here is our situation and current setup:
Postgresql 7.2.1
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 8G