[pgpool-general: 3947] 回复： Re: pgpool establish new connection too slow

[liujinfei]

When testing is runing.


I found the num of backend pg process as follows (with pgpool) :
[postgres at postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l
1
[postgres at postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l
1
[postgres at postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l
2
[postgres at postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l
2
[postgres at postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l
1


But test direct with postgres (without pgpool):


[postgres at postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l
334
[postgres at postgresql1 bin]$ ps x|grep postgres|grep 'postgres: nopass pgbench'|grep -v 'idle'|wc -l
656


I think that is why the tps (testing without pgpool) is much higher than testing with pgpool .





地址：广州市珠江新城花城大道18号建滔广场2101室 （邮编：510000）
Phone：+86 137 5171 0549
Email：liujinfei at xiangrikui.com
Skype : scofier.liu




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


Fix 192.168.9203 with 192.168.9.133


pgbench -l -c $CLIENTS -T $TIME -r pgbench -p5432 -h192.168.9.133 -Unopass


Phone：+86 137 5171 0549
Email：liujinfei at xiangrikui.com
Skype : scofier.liu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150810/c5359711/attachment.htm>