Initial database loading and IDE x SCSI - Mailing list pgsql-performance

From
Subject Initial database loading and IDE x SCSI
Date
Msg-id PEEPKDFEHHEMKBBFPOOKCEHCCPAA.carlosreimer@terra.com.br
Whole thread Raw
Responses Re: Initial database loading and IDE x SCSI
Re: Initial database loading and IDE x SCSI
Re: Initial database loading and IDE x SCSI
List pgsql-performance
Hi,

I would like to know if my supposition is right.

Considering an environment with only one hard disk attached to a server, an
initial loading of the database probably is much faster using an IDE/ATA
interface with write-back on than using an SCSI interface. That´s because of
the SCSI command interface overhead.

Then main advantage of SCSI interfaces, the multiuser environment is lost in
this scenery.

Am I right? Am I missing something here?

Even if I´m right, is something that could be done too improove SCSI loading
performance in this scenery?

Thanks in advance!

Reimer


pgsql-performance by date:

Previous
From: "Gourish Singbal"
Date:
Subject: Re: help me problems with pg_clog file
Next
From: Scott Marlowe
Date:
Subject: Re: Initial database loading and IDE x SCSI