| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Upgrade questions |
| Date: | 2012-03-14 20:34:02 |
| Message-ID: | 4F6100BA.4010909@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 03/14/12 12:53 PM, Scott Marlowe wrote:
> Note that if you don't need a lot of storage you can often use 300G
> 15k SAS drives which are around $300 each. 20 of those in a RAID-10
> gives you ~3TB of storage which is plenty for most transactional
> applications.
I'm actually using 25 x 146gb 15k SAS2 as we didn't need space, just
speed, so the 20xraid10 is 1.4TB. most of our database tests to date
have been in the 50-100GB range. and they shread at IOPS. the
controller and/or IO channels seems to bottleneck somewhere up around
1.2GB/sec sustained write, or at about 12000 write IOPS.
afaik, the HP P411 raid card is a LSI Logic megasas2 card with HP
firmware, the hardware is equivalent to the LSI 9260-8i. the HP
firmware is somewhat less annoying than the LSI megacli stuff.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-03-14 20:54:38 | Re: Searching email, Full Text Search prefix, not expected results |
| Previous Message | Scott Marlowe | 2012-03-14 19:53:19 | Re: Upgrade questions |