On Fri, 7 Sep 2007, Tobias Brox wrote:
We're also considering to install postgres on SAN - that is, my boss is convinced this is the right way to go. Advantages: 1. Higher I/O (at least the salesman claims so)
Shockingly, the salesman is probably lying to you. The very concept of SAN says that you're putting something in between your system and the disks, and that something therefore must slow things down compared to connecting directly. iSCSI, FC, whatever you're using as the communications channel can't be as fast as a controller card with a good interface straight into the motherboard. For example, a PCI-E x16 disk controller card maxes out at 4GB/s in each direction; good luck bonding enough iSCSI or FC channels together to reach that transfer rate and getting something even remotely cost-competative with an internal card.
The cases where a SAN can improve upon performance over direct discs are when the comparison isn't quite fair; for example:
1) The SAN allows spreading the load over more disks than you can fit internally in the system 2) The SAN provides a larger memory cache than the internal cards you're comparing against
If you're in one of those situations, then perhaps the salesman's claim could have some merit. There are lots of reasons one might want to use a SAN, but a higher I/O rate when fairly comparing to connecting disks directly is unlikely to be on that list.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
