<div dir="ltr">There's an important distinction between Pgpool and Pgbouncer in your example. Pgpool is aware of the difference between reads and writes and can route the requests to the correct backend, while Pgbouncer is not. Pgpool can also handle failover/master failure if you configure it to do so and Pgbouncer can't.<div><br></div><div>As far as scale, I think the issue for both is how much memory (and, to a lesser extent, CPU) you can dedicate to the pool. Both are going to create processes to handle connections, so the more connections the more processes/memory you'll use.</div><div><br></div><div><br></div><div> alex</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jun 4, 2015 at 3:48 AM, Gurunadh Venkata <span dir="ltr"><<a href="mailto:gurunadh.venkata@gmail.com" target="_blank">gurunadh.venkata@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Group,<div><br></div><div>.</div><div><span style="font-size:12.8000001907349px"> Can pg pool differentiate the read & write requests from app server.?</span><br></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"> DB Server goes down with say some 1000 hits or so.. How can we handle the traffic say, even 2000+.? Which of the Pgpool or Pgbouncer middleware will be used in this case?</span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><div><div><div dir="ltr"><br>Thanks For Your Time.<br><br>Thanks & Regards,<br>G V Gurunadh.</div></div></div>
</div><img width="1" height="1"></div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>