On 12/11/2012 06:04 PM, Niels Kristian Schjødt wrote: > > Maybe I should mention, that I never see more than max 5Gb out of my total > 32Gb being in use on the server… Can I somehow utilize more of it? For an update-mostly workload it probably won't do you tons of good so long as all your indexes fit in RAM. You're clearly severely bottlenecked on disk I/O not RAM. > The SSD's I use a are 240Gb each which will grow too small within a > few months - so - how does moving the whole data dir onto four of > those in a RAID5 array sound?
Not RAID 5! Use a RAID10 of four or six SSDs. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
