Re: Initial database loading and IDE x SCSI

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: carlosreimer(at)terra(dot)com(dot)br
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Initial database loading and IDE x SCSI
Date: 2006-06-02 18:43:00
Message-ID: 9064.1149273780@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<carlosreimer(at)terra(dot)com(dot)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. Thats 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message carlosreimer 2006-06-02 19:54:50 RES: Initial database loading and IDE x SCSI
Previous Message Mark Lewis 2006-06-02 18:41:27 Re: Initial database loading and IDE x SCSI