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

From Tom Lane
Subject Re: Initial database loading and IDE x SCSI
Date
Msg-id 9064.1149273780@sss.pgh.pa.us
Whole thread Raw
In response to Initial database loading and IDE x SCSI  (<carlosreimer@terra.com.br>)
Responses RES: Initial database loading and IDE x SCSI  (<carlosreimer@terra.com.br>)
List pgsql-performance
<carlosreimer@terra.com.br> writes:
> 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.

I *seriously* doubt that.

If you see a difference in practice it's likely got more to do with the
SCSI drive not lying about write-complete ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Mark Lewis
Date:
Subject: Re: Initial database loading and IDE x SCSI
Next
From:
Date:
Subject: RES: Initial database loading and IDE x SCSI