Thread: connection poolers' db connections
Hello,
tweaking our connection pooler (pgbouncer) and posgres 8.4 seemed a bit confusing to us.
Which key should i set for changing the limit of connection between pgbouncer <->posgres8.4?
i think configurations such as max_client_conn, default_pool_size, default_pool_size etc of pgbouncer are related to limit of connections between application <-> pgbouncer
I want to increase the connections of pgbouncer opened on posgres (pgbouncer<->posgres) to eliminate waiting connections in the pool, to consume queries faster.
any ideas about that?
Best regards,
Yetkin Ozturk
Yetkin Öztürk <yetkin85@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
Hi Kevin,
thanks for responding. I understand its a world of bottlenecks, different combinations of producer-consumer problems,
Beyond a certain point, starting the query sooner will cause it to
finish later. Really.
but I think in our situation our Postgres server can consume more connections, at least i'll give a try.
Yetkin.
2013/2/13 Kevin Grittner <kgrittn@ymail.com>
Yetkin Öztürk <yetkin85@gmail.com> wrote:The options which end in _pool_size. max_client_conn specifies how
> Which key should i set for changing the limit of connection
> between pgbouncer <-> posgres8.4?
many application connections can be made to pgbouncer.
It's generally best to use pool_mode of transaction if you can.Be sure to read this:
> I want to increase the connections of pgbouncer opened on posgres
> (pgbouncer<->posgres) to eliminate waiting connections in the
> pool, to consume queries faster.
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