I have a PostgreSQL database (OLTP, 10GB in size) server and I'm planning an array of hdds for it's storage. I have various disks I can use. I need to find the best ones for the job with the right kind of RAID configuration.
What to look? IOPS, MB/s, 4k/512k, what queue depth? What tools to use for measuring (and in which configuration)?
It's a virtual machine so I can use the Performance tab and esxtop, too, if they provide some useful information for the task.