RES: RES: Initial database loading and IDE x SCSI

Поиск
Список
Период
Сортировка
От
Тема RES: RES: Initial database loading and IDE x SCSI
Дата
Msg-id PEEPKDFEHHEMKBBFPOOKMEHHCPAA.carlosreimer@terra.com.br
обсуждение исходный текст
Ответ на Re: RES: Initial database loading and IDE x SCSI  (Mark Lewis <mark.lewis@mir3.com>)
Ответы Re: RES: RES: Initial database loading and IDE x SCSI  (Mark Lewis <mark.lewis@mir3.com>)
Список pgsql-performance
Many thanks Mark,

I will consider fsync=off only to do an initial load, not for a database normal operation.

I was just thinking about this hipotetical scenario:
a) a restore database operation
b) fsync off
c) write-back on (IDE)

As I could understand, in this sceneraio, it´s normal the IDE drive be faster than the SCSI, ok?

Of course, the database is exposed because of the fsync=off, but if you consider only the system performance, then it
istrue. Isn´t it? 

Thanks,

Reimer



В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Lewis
Дата:
Сообщение: Re: RES: Initial database loading and IDE x SCSI
Следующее
От: Mark Lewis
Дата:
Сообщение: Re: RES: RES: Initial database loading and IDE x SCSI