Re: How to improve db performance with $7K? - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: How to improve db performance with $7K?
Date
Msg-id 20050420001523.GU58835@decibel.org
Whole thread Raw
In response to Re: How to improve db performance with $7K?  (Richard_D_Levine@raytheon.com)
Responses What to do with 6 disks?  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-performance
On Tue, Apr 19, 2005 at 11:22:17AM -0500, Richard_D_Levine@raytheon.com wrote:
>
>
> pgsql-performance-owner@postgresql.org wrote on 04/19/2005 11:10:22 AM:
> >
> > What is 'multiple initiators' used for in the real world?
>
> I asked this same question and got an answer off list:  Somebody said their
> SAN hardware used multiple initiators.  I would try to check the archives
> for you, but this thread is becoming more of a rope.
>
> Multiple initiators means multiple sources on the bus issuing I/O
> instructions to the drives.  In theory you can have two computers on the
> same SCSI bus issuing I/O requests to the same drive, or to anything else
> on the bus, but I've never seen this implemented.  Others have noted this
> feature as being a big deal, so somebody is benefiting from it.

It's a big deal for Oracle clustering, which relies on shared drives. Of
course most people doing Oracle clustering are probably using a SAN and
not raw SCSI...
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: How to improve db performance with $7K?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: immutable functions vs. join for lookups ?