Re: How to improve db performance with $7K?

On Tue, Apr 19, 2005 at 11:22:17AM -0500, Richard_D_Levine(at)raytheon(dot)com wrote:
>
>
> pgsql-performance-owner(at)postgresql(dot)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(at)decibel(dot)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?"