On Mon, Oct 24, 2011 at 11:53 AM, David Boreham <david_list@xxxxxxxxxxx> wrote: > > A few quick thoughts: > > 1. 320 would be the only SSD I'd trust from your short-list. It's the only > one with proper protection from unexpected power loss. yeah. > 2. Multiple RAID'ed SSDs sounds like (vast) overkill for your workload. A > single SSD should be sufficient (will get you several thousand TPS on > pgbench for your DB size). Also, raid controllers interfere with TRIM. > 3. Consider not using the magnetic disks at all (saves on space, power and > the cost of the RAID controller for them). Agree. If one SSD did not deliver the tps, I'd consider buying more and optimizing with jbod/tablespaces -- really doubt that's necessary however. Maybe a single large slow magnetic disk is a good idea for retaining backups though. > 4. Consider using Intel 710 series rather than 320 (pay for them with the > money saved from #3 above). Those devices have much, much higher specified > endurance than the 320s and since your DB is quite small you only need to > buy one of them. 710 is good idea if and only if you are worried about write durability (in which case it's a great idea). merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
