pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
connection poolers' db connections 3+ messages / 2 participants [nested] [flat]
* connection poolers' db connections @ 2013-02-13 13:47 Yetkin Öztürk <yetkin85@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: Yetkin Öztürk @ 2013-02-13 13:47 UTC (permalink / raw) To: pgsql-performance 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: connection poolers' db connections @ 2013-02-13 14:56 Kevin Grittner <kgrittn@ymail.com> parent: Yetkin Öztürk <yetkin85@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: Kevin Grittner @ 2013-02-13 14:56 UTC (permalink / raw) To: Yetkin Öztürk <yetkin85@gmail.com>; pgsql-performance 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: connection poolers' db connections @ 2013-02-13 15:35 Yetkin Öztürk <yetkin85@gmail.com> parent: Kevin Grittner <kgrittn@ymail.com> 0 siblings, 0 replies; 3+ messages in thread From: Yetkin Öztürk @ 2013-02-13 15:35 UTC (permalink / raw) To: Kevin Grittner <kgrittn@ymail.com>; +Cc: pgsql-performance 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: > > > 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 > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-02-13 15:35 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2013-02-13 13:47 connection poolers' db connections Yetkin Öztürk <yetkin85@gmail.com> 2013-02-13 14:56 ` Kevin Grittner <kgrittn@ymail.com> 2013-02-13 15:35 ` Yetkin Öztürk <yetkin85@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox