[pgpool-general: 3941] Re: pgpool establish new connection too slow

[liujinfei]

Dear Tatsuo Ishii, Thanks for your reply:








pgpool :   192.168.9.132 (master), 192.168.9.133(slaver)
postgresql: 192.168.9.132 (slaver),  192.168.9.133(master)
pgbench   192.168.9.203




When i test with postgresql, it cost a little time ( 5 seconds) to establish new connection.


pgbench -l -c 1024 -t 5 -r pgbench -p5432 -h192.168.9.133 -Unopass




Phone：+86 137 5171 0549
Email：liujinfei at xiangrikui.com
Skype : scofier.liu




原始邮件
发件人:Tatsuo Ishiiishii at postgresql.org
收件人:liujinfeiliujinfei at xiangrikui.com
抄送:pgpool-generalpgpool-general at pgpool.net
发送时间:2015年8月10日(周一) 12:38
主题:Re: [pgpool-general: 3939] pgpool establish new connection too slow


 I have test pgpool with pgbench as follows:    pgbench -l -c 1024 -t 5 -r pgbench -p9999 -h192.168.9.190 -Unopass    I find pgpool cost a lot of time (20 seconds) to establish 1024 connection.    2015-08-10 19:58:20: pid 18756: DETAIL: connecting host=192.168.9.203 port=34465  2015-08-10 19:58:21: pid 18206: LOG: new connection received  2015-08-10 19:58:21: pid 18206: DETAIL: connecting host=192.168.9.203 port=34466  2015-08-10 19:58:21: pid 19039: LOG: new connection received    How to config pgpool.conf to speed up new connection? I assume you run pgbench on 192.168.9.203, pgpool-II is running on 192.168.9.190 and PostgreSQL runs somewhere (you didn't mention it). I recommend you to run pgbench against PostgreSQL and see how long the connection establish time is: pgbench -l -c 1024 -t 5 -r pgbench -p9999 -h IP_PostgreSQL_RUNS_ON -Unopass If it's something like 20 seconds, pgpool-II has not much to do with it because the overhead comes from PostgreSQL. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150810/6b54aefe/attachment.html>