> Hi, > > i was doing some tests in my laptop with pgpool II and i'm starting to > think that i'm not understanding the use of these parameters... > > my test: > > postgresql.conf's max_connections: 200 > > num_init_children: 50 > max_pool: 4 > > i was under the impression that that configuration will allow me to > attend until 200 clients trough pgpool, but when i run this command: > > pg_bench -p 9999 -c 60 -t 3 -f custom_script1 -f custom_script2 [some > more scripts] -d dbname > > it simply sits and does nothing, if i add the -C options it lets the > first statement of the 60 clients and then sits forever > > what am i doing wrong?
pgbench does not work as you expected. it will not start the transaction processing until all clients successfully connect to pgool. So if you want to have -c 60 with pgbench, you need to increase num_init_children to 60, at least. -- Tatsuo Ishii SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
