From: | "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | Scott Whitney <swhitney(at)journyx(dot)com> |
Subject: | Re: Opinions on SSDs |
Date: | 2013-08-12 18:18:17 |
Message-ID: | 20130812141817.6377101d@hydrogen.roaringpenguin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, 12 Aug 2013 11:01:09 -0500 (CDT)
Scott Whitney <scott(at)journyx(dot)com> wrote:
> When you say "16 10K drives," do you mean:
I mean 8 RAID-1 pairs with data striped across the pairs. The Linux
software RAID "offset" scheme is described here:
> The SSD solution I put in has shown significant speed improvements,
> to say the very least.
OK; thanks.
> Basically, just assume that you're getting 130 iops per drive. Well,
> 16 drives in a RAID 0 is going to max you out at 2100ish iops,
With our RAID-10 array, we're looking at about 1050 iops. Our server
currently is holding up OK with a decidedly non-optimal arrangment
(four RAID-1 volumes with pg_xlog on one, most DB files on a second,
and a couple of tablespaces with hand-placed tables and indexes on the
other two, and only 7200 RPM disks.)
So I think 16 10Krpm spinning disks will probably suffice; the failure mode
of SSDs makes me nervous.
Regards,
David.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-08-12 20:05:04 | Re: Opinions on SSDs |
Previous Message | Scott Whitney | 2013-08-12 16:01:09 | Re: Opinions on SSDs |