Hi Everyone On 20/06/05, Lennart Sorensen ([EMAIL PROTECTED]) wrote: > On Mon, Jun 20, 2005 at 03:49:33PM -0400, Nathan Dragun wrote: > > Woops, sorry about that bit of mis-information. > > > > What kind of performance gains have they been showing over the IDE/SCSI > > interface SATA drives, any clue? > > Well most drives have never hit the speed limits of the interface they > use, so in terms of raw throughput you generally won't see a difference. ...
We intend to use 2 SCSI disks in RAID1 for the system and the others in RAID10 for the DB. There is (obviously) a lot of debate about SATA vs SCSI on the Postgresql list. The general opinion is that 7200 rpm SATA disks just aren't fast/smart enough to cut it for serious database use, 10K Raptors being a possible exception. Since SCSI drives are designed "to do physical I/O scheduling, because the CPU can issue multiple commands before the drive has to report completion of the first one. IDE isn't designed to do that..." [Tom Lane], we're going for that. Cheers Rory -- Rory Campbell-Lange <[EMAIL PROTECTED]> <www.campbell-lange.net> -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
