Recently I am been testing few pieces of Storage projects of OpenSolaris with PostgreSQL. One of tests involves using an iSCSI disk with PostgreSQL. Unfortunately the storage that's available is in Colorado while my PostgreSQL server is located in Massachusetts. Latency will definitely be one of my top problems since storage is halfway across the country (in Colorado). Plus the fact that I will be running a database server on my end doesn't really sound like a good idea. Come to think about it, this could be a more common problem nowadays since Cloud Storage (for example Amazon S3 Webservice ) could be optimistically half way across the country and pessimistically be on the other side of the world.
So what are my options to solve such[Read more...]