Re: Some Performance Advice Needed

Поиск
Список
Период
Сортировка
От Jeff
Тема Re: Some Performance Advice Needed
Дата
Msg-id 27CB29DA-54F1-11D9-9712-000D9366F0C4@torgo.978.org
обсуждение исходный текст
Ответ на Some Performance Advice Needed  (Alex <alex@meerkatsoft.com>)
Ответы Re: Some Performance Advice Needed
Список pgsql-performance
On Dec 23, 2004, at 9:27 AM, Alex wrote:


> Running hdparm reported
> A) 920mb/s   (SCSI 10k)
> B) 270mb/s   (SCSI 10k)
> C) 1750mb/s  (IDE  7.2k)


IDE disks lie about write completion (This can be disabled on some
drives) whereas SCSI drives wait for the data to actually be written
before they report success.  It is quite
easy to corrupt a PG (Or most any db really) on an IDE drive.  Check
the archives for more info.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/


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

Предыдущее
От: Alex
Дата:
Сообщение: Some Performance Advice Needed
Следующее
От: William Yu
Дата:
Сообщение: Re: Some Performance Advice Needed