<div style="font:14px/1.5 'Lucida Grande', '微软雅黑';color:#333;"><p style="font:14px/1.5 'Lucida Grande';margin:0;"><br></p><p style="font:14px/1.5 'Lucida Grande';margin:0;">When testing is runing. </p><p style="font:14px/1.5 'Lucida Grande';margin:0;"><br></p><p style="font:14px/1.5 'Lucida Grande';margin:0;">I found the num of backend pg process as follows (with pgpool) :</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">[postgres@postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">1</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">[postgres@postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">1</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">[postgres@postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">2</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">[postgres@postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">2</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">[postgres@postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">1</p><p style="font:14px/1.5 'Lucida Grande';margin:0;"><br></p><p style="font:14px/1.5 'Lucida Grande';margin:0;">But test direct with postgres (without pgpool):</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);"><br></p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">[postgres@postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">334</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">[postgres@postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">
</p><p style="margin: 0px; font-size: 12px; line-height: normal; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);">656</p><p style="font:14px/1.5 'Lucida Grande';margin:0;"><br></p><p style="font:14px/1.5 'Lucida Grande';margin:0;">I think that is why the tps (testing without pgpool) is much higher than testing with pgpool .</p><p style="font:14px/1.5 'Lucida Grande';margin:0;"><br></p><p style="font:14px/1.5 'Lucida Grande';margin:0;"> </p><div><div style="font: 14px/1.5 'Lucida Grande';"><div class="sign" style="color: rgb(51, 51, 51); widows: 1; padding: 20px 10px; line-height: 22px; font-family: 'Lucida Grande', 'Lucida Sans Unicode', sans-serif !important;"><br></div><div class="sign" style="color: rgb(51, 51, 51); widows: 1; padding: 20px 10px; line-height: 22px; font-family: 'Lucida Grande', 'Lucida Sans Unicode', sans-serif !important;"><div class="contact" style="border-bottom-color: rgb(229, 229, 229); padding: 15px 0px; margin-top: 18px; border-top-color: rgb(229, 229, 229); border-top-width: 1px; border-top-style: solid;"><p style="margin-top: 0px; margin-bottom: 10px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;">地址：广州市珠江新城花城大道18号建滔广场2101室 （邮编：510000）</p><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;">Phone：+86 137 5171 0549</p><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;">Email：<a href="mailto:liujf3@ucweb.com" target="_blank" title="mailto:liujf3@ucweb.com" style="color: rgb(19, 109, 186); text-decoration: none; -webkit-user-drag: none;">liujinfei@xiangrikui.com</a></p><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;">Skype : scofier.liu</p><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;"><br></p></div></div></div></div><span style="font: 14px/1.5 'Lucida Grande';color:#333;"><br></span><div class="foxmail_blockquote_fromhere_element" style="font: 12px/1.5 'Lucida Grande';padding:2px 0 2px 0;"><span style="color:#333;text-decoration:line-through;white-space:pre-wrap;"> </span> 原始邮件 <span style="color:#333;text-decoration:line-through;white-space:pre-wrap;"> </span></div><div style="font: 12px/1.5 'Lucida Grande';background:#efefef;color:#666666;padding:8px;"><div><b style="color:#999;">发件人:</b> liujinfei<liujinfei@xiangrikui.com></div><div><b style="color:#999;">收件人:</b> Tatsuo Ishii<ishii@postgresql.org></div><div><b style="color:#999;">抄送:</b> pgpool-general<pgpool-general@pgpool.net></div><div><b style="color:#999;">发送时间:</b> 2015年8月10日(周一) 18:17</div><div><b style="color:#999;">主题:</b> [pgpool-general: 3946] Re: pgpool establish new connection tooslow</div></div><br><div class="mail_quote_6681D9890ED54731B301999461229F6B" style="font: 14px/1.5 'Lucida Grande';color:#333;"><div style="font:14px/1.5 'Lucida Grande', '微软雅黑';color:#333;"><p style="font:14px/1.5 'Lucida Grande';margin:0;">Fix 192.168.9203 with 192.168.9.133</p><p style="font:14px/1.5 'Lucida Grande';margin:0;"><br></p><div><div style="font: 14px/1.5 'Lucida Grande';"><div class="sign" style="color: rgb(51, 51, 51); widows: 1; padding: 20px 10px; line-height: 22px; font-family: 'Lucida Grande', 'Lucida Sans Unicode', sans-serif !important;"><pre style="line-height: 21px; white-space: pre-wrap; font-family: 'Lucida Grande', 'Lucida Sans Unicode', sans-serif !important;"><p style="margin: 0px; font-size: 12px; line-height: normal; background-color: rgb(0, 0, 0);"><span style="color: rgb(41, 249, 20);">pgbench -l -c $CLIENTS -T $TIME -r pgbench -</span><font color="#ce3b00">p5432</font><font color="#29f914"> -h192.168.9.</font><font color="#dd2067">133</font><font color="#29f914"> -Unopass</font></p><div><br></div></pre></div><div class="sign" style="color: rgb(51, 51, 51); widows: 1; padding: 20px 10px; line-height: 22px; font-family: 'Lucida Grande', 'Lucida Sans Unicode', sans-serif !important;"><div class="contact" style="border-bottom-color: rgb(229, 229, 229); padding: 15px 0px; margin-top: 18px; border-top-color: rgb(229, 229, 229); border-top-width: 1px; border-top-style: solid;"><p style="margin-top: 0px; margin-bottom: 10px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;">Phone：+86 137 5171 0549</p><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;">Email：<a href="mailto:liujf3@ucweb.com" target="_blank" title="mailto:liujf3@ucweb.com" style="color: rgb(19, 109, 186); text-decoration: none; -webkit-user-drag: none;">liujinfei@xiangrikui.com</a></p><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;">Skype : scofier.liu</p><p style="margin-top: 0px; margin-bottom: 0px; line-height: 18px; color: rgb(118, 116, 116); font-size: 12px;"><br></p></div></div></div></div></div></div></div>