Re: Tuning the configuration

Поиск
Список
Период
Сортировка
От Evgeniy Shishkin
Тема Re: Tuning the configuration
Дата
Msg-id 63042BAB-3B28-441F-B819-B2DDC8FB24EE@gmail.com
обсуждение исходный текст
Ответ на Re: Tuning the configuration  ("Graeme B. Bell" <grb@skogoglandskap.no>)
Список pgsql-performance
> On 16 Dec 2014, at 14:51, Graeme B. Bell <grb@skogoglandskap.no> wrote:
>
>>
>> I don't understand the logic behind using drives,
>> which are best for random io, for sequent io workloads.
>
> Because they are also best for sequential IO. I get 1.3-1.4GB/second from 4 SSDs in RAID or >500MB/s for single disk
systems,even with cheap models.  
> Are you getting more than that from high-end spinning rust?


I better use ssd for random iops when database doesn't fit in ram.
For wal logs i use raid with bbu cache and couple of sas drives.



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

Предыдущее
От: "Graeme B. Bell"
Дата:
Сообщение: Re: Tuning the configuration
Следующее
От: Strahinja Kustudić
Дата:
Сообщение: Re: 8xIntel S3500 SSD in RAID10 on Dell H710p