Initial database loading and IDE x SCSI

Поиск
Список
Период
Сортировка
От
Тема Initial database loading and IDE x SCSI
Дата
Msg-id PEEPKDFEHHEMKBBFPOOKCEHCCPAA.carlosreimer@terra.com.br
обсуждение исходный текст
Ответы Re: Initial database loading and IDE x SCSI  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Initial database loading and IDE x SCSI  (Mark Lewis <mark.lewis@mir3.com>)
Re: Initial database loading and IDE x SCSI  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Gourish Singbal"
Дата:
Сообщение: Re: help me problems with pg_clog file
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Initial database loading and IDE x SCSI