From: carlosreimer@terra.com.br
To: pgsql-performance@postgresql.org
Subject: Initial database loading and IDE x SCSI
Date: Fri, 2 Jun 2006 15:25:57 -0300
Message-ID: <PEEPKDFEHHEMKBBFPOOKCEHCCPAA.carlosreimer@terra.com.br> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: carlosreimer@terra.com.br
Subject: Re: Initial database loading and IDE x SCSI
In-Reply-To: <PEEPKDFEHHEMKBBFPOOKCEHCCPAA.carlosreimer@terra.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox