Re: which dual-CPU hardware/OS is fastest for PostgreSQL?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Дата
Msg-id 87wtrr1mih.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-performance
"Joshua D. Drake" <jd@commandprompt.com> writes:

> > I assume AMCC == 3ware now?
> >
> > Has anyone verified that fsync is safe on these controllers? Ie, that they
> > aren't caching writes and "lying" about the write completing like IDE
> > drives often do by default?
>
> The higher end AMCC/3ware controllers actually warn you about using
> write-cache. You have to explicitly turn it on within the controller
> bios.

Well that's a good sign.

But if they're using SATA drives my concern is that the drives themselves may
be doing some caching on their own. Has anyone verified that the controllers
are disabling the drive cache or issuing flushes or doing something else to be
sure to block the drives from caching writes?

--
greg

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Delete query takes exorbitant amount of time
Следующее
От: Cott Lang
Дата:
Сообщение: Re: How to improve db performance with $7K?