> On 16 Dec 2014, at 14:51, Graeme B. Bell <g...@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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
