title: Load balance/distribution for postgresql
body: <p>I am coming here after spending considerable time trying to understand how to implement load balancing (distributing database processing load) between postgresql database servers. </p>
  
  <p>I have a postgresql system which attracts about 100s of transactions per second and this is likely to grow. Please do note that my case has so many updates + inserts + selects as well. So any solution for me needs to cater to all insert/update and reads.</p>
  
  <ul>
  <li>I am planning to use plproxy as suggested through db tools from skype at <a href="http://www.slideshare.net/adorepump/database-tools-by-skype" rel="nofollow">http://www.slideshare.net/adorepump/database-tools-by-skype</a>. </li>
  <li>Now I am also hearing that "postgresql streaming replication + hot standby" in postgres 9.0 can be considered</li>
  </ul>
  
  <p>Can someone suggest me  if there is any simple (or complex) solution to implement for the above scenario? </p>