Re: Tuning guidelines for server with 256GB of RAM and SSDs?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Tuning guidelines for server with 256GB of RAM and SSDs?
Дата
Msg-id CAOR=d=13st6GcimEaMD-mMftBkeB7fhhgPWop-CASpFGyHyOaw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Tuning guidelines for server with 256GB of RAM and SSDs?  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: Tuning guidelines for server with 256GB of RAM and SSDs?  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
On Wed, Jul 6, 2016 at 12:13 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> Disabling write back cache for write heavy database loads will will
> destroy it in short order due to write amplication and will generally
> cause it to underperform hard drives in my experience.

Interesting. We found our best performance with a RAID-5 of 10 800GB
SSDs (Intel 3500/3700 series) that we got MUCH faster performance with
all write caching turned off on our LSI MEgaRAID controllers. We went
from 3 to 4ktps to 15 to 18ktps. And after a year of hard use we still
show ~90% life left (these machines handle thousands of writes per
second in real use) It could be that the caching was getting in the
way of RAID calcs or some other issue. With RAID-1 I have no clue what
the performance will be with write cache on or off.

--
To understand recursion, one must first understand recursion.


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Tuning guidelines for server with 256GB of RAM and SSDs?
Следующее
От: "Wes Vaske (wvaske)"
Дата:
Сообщение: Re: Tuning guidelines for server with 256GB of RAM and SSDs?