[Pgpool-general] pgbench hangs with pgpool II when count of connection is bigger than num_init_children
Pavel Stehule
pavel.stehule at gmail.com
Wed Apr 16 10:31:05 UTC 2008
Hello
I am testing pgpool II. I have small problem. If I understand to
documentation well, then pg_pool can create num_init_children *
max_pool connection. For default connection this is 128 connection.
But when I check pgbench with 33 connection, then pgbench hangs
number of clients: 30
number of transactions per client: 10
number of transactions actually processed: 300/300
tps = 127.959981 (including connections establishing)
tps = 129.241212 (excluding connections establishing)
[pavel at localhost etc]$ pgbench -c 32 -p 9999 postgres
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 32
number of transactions per client: 10
number of transactions actually processed: 320/320
tps = 173.632024 (including connections establishing)
tps = 175.622403 (excluding connections establishing)
[pavel at localhost etc]$ pgbench -c 33 -p 9999 postgres
starting vacuum...end.
why?
what is wrong on my expectation?
Regards
Pavel Stehule
More information about the Pgpool-general
mailing list