> pgbench cannot be used for testing with pgbouncer if number of > pgbench clients exceeds pool_size + reserve_pool_size of pgbouncer. > pgbench keeps waiting doing nothing. I am using pgbench of postgresql 8.1. > Are there changes to pgbench in this aspect ?
Pgbench won't start actual transaction until all connections to PostgreSQL (in this case pgbounser I guess) successfully established. IMO You sholud try other benchmark tools. BTW, I think you should use -C option with pgbench for this kind of testing. -C establishes connection for each transaction, which is pretty much similar to the real world application which do not use connection pooling. You will be supprised how PostgreSQL connection overhead is large. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
