Re: Some Performance Advice Needed

Поиск
Список
Период
Сортировка
От William Yu
Тема Re: Some Performance Advice Needed
Дата
Msg-id cqfecl$2bmm$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Some Performance Advice Needed  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-performance
>> 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.
>
>
> Do we have any real info on this? Specifically which drives? Is SATA the
> same way? What about SATA-II?
> I am not saying it isn't true (I know it is) but this is a blanket
> statement that may or may not be
> true with newer tech.

 From my experience with SATA controllers, write caching is controlled
via the BIOS.

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Some Performance Advice Needed
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Memory leak tsearch2 VACUUM FULL VERBOSE ANALYZE