Re: Tuning the configuration - Mailing list pgsql-performance

From Evgeniy Shishkin
Subject Re: Tuning the configuration
Date
Msg-id 63042BAB-3B28-441F-B819-B2DDC8FB24EE@gmail.com
Whole thread Raw
In response to Re: Tuning the configuration  ("Graeme B. Bell" <grb@skogoglandskap.no>)
List 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 by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: Tuning the configuration
Next
From: Strahinja Kustudić
Date:
Subject: Re: 8xIntel S3500 SSD in RAID10 on Dell H710p