Re: BUG #15759: Lot of idle connection created by "SET extra_float_digits = 3"

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: anup singh <midas(dot)anup(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15759: Lot of idle connection created by "SET extra_float_digits = 3"
Date: 2019-04-16 12:37:05
Message-ID: 20190416123705.m3ved2p656qxxaoh@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Apr 16, 2019 at 05:31:42PM +0530, anup singh wrote:
>Hi Tomas,
>
>Thanks for your response. Kindly see the below screen shot where we have
>lot of idle connection which is reaching max pool size soon, but the actual
>request is only one.
>

I'm pretty sure that's the expected behavior of a connection pool. It
opens a bunch of connections, does some initialization on them (which
likely includes the "SET extra_float_digits = 3" bit) and then keeps them
around so that the application can use them.

You have not really explained how it's killing your application, though.
My guess is it's either not going through the connection pool (and so is
hitting max_connections or something) or it's misconfigured in some other
way. In any case, extra_float_digits is not the root cause here.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-04-16 13:00:58 BUG #15760: Error to start PGAdmin 4.5
Previous Message anup singh 2019-04-16 12:01:42 Re: BUG #15759: Lot of idle connection created by "SET extra_float_digits = 3"