Re: [PERFORM] advice on raid controller

2003-10-02 Thread Vivek Khera
> "RJ" == Richard Jones <[EMAIL PROTECTED]> writes: RJ> Hi, i'm on the verge of buying a "MegaRAID SCSI 320-2" raid controller. RJ> I need it to build a db server using 4x ultra320 scsi disks RJ> i'm thinking raid 1+0 but will try with raid5 too and compare No specific tips on that particular

Re: [PERFORM] advice on raid controller

2003-10-02 Thread Vivek Khera
> "PG" == Palle Girgensohn <[EMAIL PROTECTED]> writes: PG> Come to think of it, I guess a battery-backed cache will make fsync as PG> fast as no fsync, right? So, the q was kinda stoopid... :-/ In my testing, yes, the battery cache makes fsync=true just about as fast as fsync=false. it was o

Re: [PERFORM] advice on raid controller

2003-09-29 Thread Bruce Momjian
\Palle Girgensohn wrote: > Come to think of it, I guess a battery-backed cache will make fsync as fast > as no fsync, right? So, the q was kinda stoopid... :-/ With fsync off, the data might never get to the battery-backed RAM. :-( -- Bruce Momjian| http://candle.pha

Re: [PERFORM] advice on raid controller

2003-09-29 Thread Matt Clark
r 2003 22:32 > To: Matt Clark; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [PERFORM] advice on raid controller > > > Stupid question, perhaps, but would a battery-backed cache make > it safe to > set fsync=false in postgresql.conf? > > /Palle > > --On

Re: [PERFORM] advice on raid controller

2003-09-29 Thread Palle Girgensohn
Come to think of it, I guess a battery-backed cache will make fsync as fast as no fsync, right? So, the q was kinda stoopid... :-/ /Palle --On måndag, september 29, 2003 23.31.54 +0200 Palle Girgensohn <[EMAIL PROTECTED]> wrote: Stupid question, perhaps, but would a battery-backed cache make i

Re: [PERFORM] advice on raid controller

2003-09-29 Thread Palle Girgensohn
Stupid question, perhaps, but would a battery-backed cache make it safe to set fsync=false in postgresql.conf? /Palle --On söndag, september 28, 2003 13.07.57 +0100 Matt Clark <[EMAIL PROTECTED]> wrote: As others have mentioned, you really ought to get battery-backed cache if you're doing any

Re: [PERFORM] advice on raid controller

2003-09-29 Thread scott.marlowe
On 29 Sep 2003, Will LaShell wrote: > On Mon, 2003-09-29 at 06:48, scott.marlowe wrote: > > I've used the megaraid / LSI cards in the past and they were pretty good > > in terms of reliability, but the last one I used was the 328 model, from 4 > > years ago or so. that one had a battery backup

Re: [PERFORM] advice on raid controller

2003-09-29 Thread Will LaShell
> > -----Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] Behalf Of Richard > > > Jones > > > Sent: 27 September 2003 18:25 > > > To: [EMAIL PROTECTED] > > > Subject: [PERFORM] advice on raid controller &g

Re: [PERFORM] advice on raid controller

2003-09-29 Thread scott.marlowe
ything else, so spend the money on that rather > than latest-and-greatest performance for a single channel. > > HTH > > Matt > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Richard > > Jones > > Sent:

Re: [PERFORM] advice on raid controller

2003-09-28 Thread Matt Clark
ather than latest-and-greatest performance for a single channel. HTH Matt > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Richard > Jones > Sent: 27 September 2003 18:25 > To: [EMAIL PROTECTED] > Subject: [PERFORM] advice on raid

Re: [PERFORM] advice on raid controller

2003-09-27 Thread Josh Berkus
RIchard, > Hi, i'm on the verge of buying a "MegaRAID SCSI 320-2" raid controller. > I need it to build a db server using 4x ultra320 scsi disks > i'm thinking raid 1+0 but will try with raid5 too and compare Depends on your type of database. If you're doing web or OLAP (lots of read-only queri

Re: [PERFORM] advice on raid controller

2003-09-27 Thread Ron Johnson
On Sat, 2003-09-27 at 12:24, Richard Jones wrote: > Hi, i'm on the verge of buying a "MegaRAID SCSI 320-2" raid controller. > I need it to build a db server using 4x ultra320 scsi disks > i'm thinking raid 1+0 but will try with raid5 too and compare > > Does anyone have any experience with this mo

Re: [PERFORM] advice on raid controller

2003-09-27 Thread Allan Wind
On 2003-09-27T18:24:33+0100, Richard Jones wrote: > i'm on the verge of buying a "MegaRAID SCSI 320-2" raid controller. You may want to check out the PCI-X version of this controller that LSILogic just released (MegaRAID SCSI 320-2X). PCI-X is backwards compatible with PCI, but also gives you gre

[PERFORM] advice on raid controller

2003-09-27 Thread Richard Jones
Hi, i'm on the verge of buying a "MegaRAID SCSI 320-2" raid controller. I need it to build a db server using 4x ultra320 scsi disks i'm thinking raid 1+0 but will try with raid5 too and compare Does anyone have any experience with this model, good or bad i'd like to know.. thanks :) as seen: htt