connection poolers' db connections

[Yetkin Öztürk]

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 <-> pgbounce*r
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

[Kevin Grittner]

Post by Yetkin Öztürk
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.

Post by Yetkin Öztürk
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

[Yetkin Öztürk]

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.

Post by Yetkin Öztürk
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.

Post by Yetkin Öztürk
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