<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:70.85pt 85.05pt 70.85pt 85.05pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><a name="_MailEndCompose"><span style="color:#1F497D">My immediate thought would be this: PGPool is much slower with a larger number of concurrent users because some of the connections are being queued by PGPool. Take a look at your num_init_children
parameter…unlike most connection pooling layers, PGPool doesn’t have separate config parameters for the initial number of backend connections and the max number of backend connections…num_init_children controls both. Increase num_init_children to at least
the number of concurrent connections plus a few, and re-try the benchmark tests.<o:p></o:p></span></a></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p> </o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D">Also, the benefits of load balancing don’t tend to show up well with pgbench or sysbench default benchmarks. PGPool imposes some overhead in determining which queries
can be load-balanced against a standby…with SELECT queries that execute in only a few milliseconds, it might take PGPool longer to make that decision than it would have to just send it straight to the primary. So, you won’t see the load balancing benefits
with SELECT queries that execute in a few milliseconds, but when you send it SELECT queries that take a few seconds or longer to execute you’ll start to see the benefits. You could create a custom benchmark that has some high-reduction queries that would
take a few seconds to execute, then run the benchmarks with that…you should then see scalability improvements from the load balancing.<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p> </o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D">Hope this helps,<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p> </o:p></span></span></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1086" style="width:407.25pt">
<tbody>
<tr>
<td colspan="3" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><img width="543" height="70" style="width:5.6562in;height:.7291in" id="Picture_x0020_1" src="cid:image001.png@01D2838C.7C51C740" alt="banner2"></span></span><span style="mso-bookmark:_MailEndCompose"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D"><o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr style="height:7.5pt">
<td style="padding:0in 0in 0in 0in;height:7.5pt">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:1.0pt;font-family:"Times New Roman",serif;color:#1F497D"> <o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in;height:7.5pt"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in;height:7.5pt"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr>
<td nowrap="" valign="top" style="padding:0in 0in 0in .25in">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">David Sisk</span></b></span><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Engineer - Software<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"></span><a href="mailto:dsisk@cisco.com"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666;text-decoration:none">dsisk@cisco.com</span></span></a><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Tel:
<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td width="550" valign="top" style="width:206.25pt;padding:0in 0in 0in 15.0pt">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Cisco Systems, Inc.<o:p></o:p></span></b></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">7025-6 Kit Creek Road PO Box 14987<br>
RESEARCH TRIANGLE PARK<br>
27709-4987<br>
United States<br>
cisco.com<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
<td style="padding:0in 0in 0in 0in"><span style="mso-bookmark:_MailEndCompose"></span></td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D;display:none"><o:p> </o:p></span></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="800" style="width:300.0pt">
<tbody>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#009900"><img border="0" width="18" height="19" style="width:.1875in;height:.1979in" id="Picture_x0020_3" src="cid:image002.gif@01D2838C.7C51C740" alt="http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif">Think
before you print.<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use,
distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">Please
</span></span><a href="http://www.cisco.com/web/about/doing_business/legal/cri/index.html" title="Legal Information"><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#0E58A0">click here</span></span><span style="mso-bookmark:_MailEndCompose"></span></a><span style="mso-bookmark:_MailEndCompose"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">
for Company Registration Information.<o:p></o:p></span></span></p>
</td>
<span style="mso-bookmark:_MailEndCompose"></span>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailEndCompose"><span style="color:#1F497D"><o:p> </o:p></span></span></p>
<span style="mso-bookmark:_MailEndCompose"></span>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net]
<b>On Behalf Of </b>Lazaro Garcia<br>
<b>Sent:</b> Thursday, February 9, 2017 5:00 AM<br>
<b>To:</b> pgpool-general@pgpool.net; pgsql-admin@postgresql.org<br>
<b>Subject:</b> [pgpool-general: 5318] Why pgpool TPS is lowest versus postgresql direct connections?<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="ES" style="color:#1F497D">The correct results reported by sysbench was:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES" style="color:#1F497D"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1085" style="width:407.0pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="445" nowrap="" valign="bottom" style="width:167.0pt;border:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:ES">Concurrent Users<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">1<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">20<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">50<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">100<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="445" nowrap="" valign="bottom" style="width:167.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:ES">PostgreSQL<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">3582<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">11943<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">12852<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">10618<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="445" nowrap="" valign="bottom" style="width:167.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:ES">Pgpool<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">2240<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">7628<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">7013<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="bottom" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 3.5pt 0in 3.5pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">6135<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="ES" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES" style="color:#1F497D">Is there any way to tuning this behavior?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES" style="color:#1F497D">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span lang="ES" style="mso-fareast-language:ES">De:</span></b><span lang="ES" style="mso-fareast-language:ES"> Lazaro Garcia [<a href="mailto:lazaro3487@gmail.com">mailto:lazaro3487@gmail.com</a>]
<br>
<b>Enviado el:</b> miércoles, 8 de febrero de 2017 05:28 p. m.<br>
<b>Para:</b> 'pgpool-general@pgpool.net'; 'pgsql-admin@postgresql.org'<br>
<b>Asunto:</b> Why pgpool TPS is lowest versus postgresql direct connections?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">After installed Pgpool with 2 postgresql nodes with streaming replication, I have noticed that access directly to postgresql is more efficient than through pgpool.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">I supposed that load balance could increase the transactions per second executed because each node could receive more load, but the results shown below are not expected.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">This is the setup:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">Pgpool 3.6.1 whit connection pooling, streaming replication mode and load balancing mode.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">2 PostgreSQL server 9.6.1 whit streaming replication.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">For the tests I used sysbench and pgbench.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">The results of sysbench:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1085" style="width:407.0pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="445" nowrap="" valign="top" style="width:167.0pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:ES">Concurrent Users<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">1<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">20<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">50<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">100<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="445" nowrap="" valign="top" style="width:167.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:ES">PostgreSQL (TPS) Direct<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">1166<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">20936<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">25743<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">27344<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="445" nowrap="" valign="top" style="width:167.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:ES">Pgpool (TPS)<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">2240<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">7628<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">7013<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">6135<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">The results of pgbench<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="915" style="width:343.0pt;border-collapse:collapse">
<tbody>
<tr style="height:15.0pt">
<td width="275" nowrap="" valign="top" style="width:103.0pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">1<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">20<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">50<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">100<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="275" nowrap="" valign="top" style="width:103.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:ES">PostgreSQL (TPS) Direct<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">1403<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">6805<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">6194<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">5726<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="275" nowrap="" valign="top" style="width:103.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal"><span style="color:black;mso-fareast-language:ES">Pgpool (TPS)<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">511<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">5430<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">5528<o:p></o:p></span></p>
</td>
<td width="160" nowrap="" valign="top" style="width:60.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" align="right" style="text-align:right"><span style="color:black;mso-fareast-language:ES">4705<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">As you can see in both cases even with load balance, the total transactions per second are lower.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">Is this the expected behavior. Is there any way to allow more TPS when pgpool is used?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">There are other publications with similar results:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES"><a href="https://www.os3.nl/_media/2011-2012/courses/lia/rory_breuk_gerrie_veerman_-_report.pdf">https://www.os3.nl/_media/2011-2012/courses/lia/rory_breuk_gerrie_veerman_-_report.pdf</a> (page 28)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><a href="http://www.mail-archive.com/pgpool-general@pgfoundry.org/msg03326.html">http://www.mail-archive.com/pgpool-general@pgfoundry.org/msg03326.html</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="ES">Regards<o:p></o:p></span></p>
</div>
</body>
</html>