| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | Yetkin Öztürk <yetkin85(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: connection poolers' db connections |
| Date: | 2013-02-13 14:56:54 |
| Message-ID: | 1360767414.10062.YahooMailNeo@web162901.mail.bf1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Yetkin Öztürk <yetkin85(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yetkin Öztürk | 2013-02-13 15:35:40 | Re: connection poolers' db connections |
| Previous Message | Yetkin Öztürk | 2013-02-13 13:47:55 | connection poolers' db connections |