When traffic goes up, my webserver creates multiple instances of postgresql.exe. At some basic level, aren't they similar to Oracle's RAC "clusters", except that they are not aware of each other? Does this mean that if I were to create copies of postgresql.exe beforehand and somehow split traffic to them, traffic could be handled better?
Also, if I install postgresql on multiple boxes, how can I load-balance- configure traffic to be split depending on load, at application or webserver level?
All this for mostly read-only data.
Cheers, Bill