On Mon, Aug 12, 2013 at 8:28 AM, David F. Skoll <dfs@xxxxxxxxxxxxxxxxxx> wrote:
3) Our current workload peaks at about 5000 transactions per second;
you can assume about one-third to one-half of those are writes. Do
you think we can get away with 16 10Krpm SATA drives instead of the
SSDs?
pgbench peaks out at 5K-7K transactions per second on my server which uses just 10ea. of 7Krpm SATA drives:
WAL: RAID1 (2 disks)
Data: RAID10 (8 disks)
3Ware RAID controller with BBU
2x4 core Intel CPUs
12 GB memory
I don't know how pgbench compares to your workload. But suspect 16 10K SATA drives would be pretty fast if you combine them with a BBU RAID controller.
On the other hand, I swore this would be the last server I buy with spinning storage.
Craig
