Yetkin Öztürk <yetki...@gmail.com> wrote: > Which key should i set for changing the limit of connection > between pgbouncer <-> posgres8.4?
The options which end in _pool_size. max_client_conn specifies how many application connections can be made to pgbouncer. It's generally best to use pool_mode of transaction if you can. > I want to increase the connections of pgbouncer opened on posgres > (pgbouncer<->posgres) to eliminate waiting connections in the > pool, to consume queries faster. Be sure to read this: http://wiki.postgresql.org/wiki/Number_Of_Database_Connections Beyond a certain point, starting the query sooner will cause it to finish later. Really. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
