[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] connection poolers' db connections
From:       Yetkin_Öztürk <yetkin85 () gmail ! com>
Date:       2013-02-13 15:35:40
Message-ID: CALL033DqJwxuQX6Xe-4-iLd5MZyEVoyNdwCGvS9DDQSk+2_PYQ () mail ! gmail ! com
[Download RAW message or body]

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 =D6zt=FCrk <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
>

[Attachment #3 (text/html)]

Hi Kevin,<div><br></div><div>thanks for responding.  I understand its a world of \
bottlenecks,  different combinations of producer-consumer problems, \
</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
 Beyond a certain point, starting the query sooner will cause it to<br>finish later.  \
Really.</blockquote><div><br></div><div>but I think in our situation our Postgres \
server can consume more connections, at least i&#39;ll give a try.</div> \
<div><br></div><div>Yetkin.</div><div><br><br><div class="gmail_quote">2013/2/13 \
Kevin Grittner <span dir="ltr">&lt;<a href="mailto:kgrittn@ymail.com" \
target="_blank">kgrittn@ymail.com</a>&gt;</span><br><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div \
class="im">Yetkin Öztürk &lt;<a \
href="mailto:yetkin85@gmail.com">yetkin85@gmail.com</a>&gt; wrote:<br> <br>
&gt; Which key should i set for changing the limit of connection<br>
&gt; between pgbouncer &lt;-&gt; posgres8.4?<br>
<br>
</div>The options which end in _pool_size.  max_client_conn specifies how<br>
many application connections can be made to pgbouncer.<br>
<br>
It&#39;s generally best to use pool_mode of transaction if you can.<br>
<div class="im"><br>
&gt; I want to increase the connections of pgbouncer opened on posgres<br>
&gt; (pgbouncer&lt;-&gt;posgres) to eliminate waiting connections in the<br>
&gt; pool, to consume queries faster.<br>
<br>
</div>Be sure to read this:<br>
<br>
<a href="http://wiki.postgresql.org/wiki/Number_Of_Database_Connections" \
target="_blank">http://wiki.postgresql.org/wiki/Number_Of_Database_Connections</a><br>
 <br>
Beyond a certain point, starting the query sooner will cause it to<br>
finish later.  Really.<br></blockquote><div><br></div><div> </div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> <span class="HOEnZb"><font color="#888888"><br>
--<br>
Kevin Grittner<br>
EnterpriseDB: <a href="http://www.enterprisedb.com" \
target="_blank">http://www.enterprisedb.com</a><br> The Enterprise PostgreSQL \
Company<br> </font></span></blockquote></div><br></div>



[prev in list] [next in list] [prev in thread] [next in thread]