Initial database loading and IDE x SCSI

Поиск
Список
Период
Сортировка
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 по дате отправления: