[pgpool-general: 4235] pgpool load balancing performance

[Ken Young]

Hey folks,

Is anyone seeing acceptable load balance scaling with pgpool-II, particularly with JDBC clients?  With one to four replicas, we are not seeing any throughput performance enhancements at all.  Through Google, I did find this article:

http://www.enterprisedb.com/postgres-plus-edb-blog/jason-davis/pgpool-ii-enables-horizontal-scalability-postgres

The results that we are seeing are similar to the reported 100 client and 300 client models that EDB tested.  We are not seeing the pop that EDB's 1000 client model shows.  Also, what load balancing tuning options are suggested?  The article mentions adjusting the primary data server backend_weight.  We haven't tried this yet, but I'm presuming that this will help with the read query throughput.


Ken Young
Ken.Young at sas.com
Data Management R&D
SAS Institute, Inc.
919-531-9319
http://www.sas.com<http://www.sas.com/>
SAS...  The Power to Know

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151120/2403ee44/attachment-0001.html>