we decided to upgrade DB server, now running on FreeBSD 8.0-STABLE, Intel(R) Xeon(R) CPU E5335 @ 2.00GHz (1995.01-MHz K8-class CPU), 8GB RAM, db running on SAS hdd with slave on another box, there are more than 2000 queries per second to database, DB size is 25 GB.
I am completely new to SSD technology, I was reading a lot of information, but I am still not sure, which SSD hard-drive would be best to buy - 32 GB should be enough, price limit for SSD is up to 1000 USD, for controller same.
I am considering to buy Intel X25-E SSD, but I saw some good results with Patriot or OCZ Vertex...
According http://it-blog.5amsolutions.com/2010/08/performance-of-postgresql-ssd-vs.html there is really big performance step over using "standard" hard drives.
Thanks for any help.