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.
http://www.postgresql.org/docs/8.3/interactive/high-availability.html
Cheers, Bill