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: midas(dot)anup(at)gmail(dot)com, 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 11:45:51
Message-ID: 20190416114551.kr6swl334plquxc5@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Apr 16, 2019 at 11:04:25AM +0000, PG Bug reporting form wrote:
>The following bug has been logged on the website:
>
>Bug reference: 15759
>Logged by: anup singh
>Email address: midas(dot)anup(at)gmail(dot)com
>PostgreSQL version: 10.7
>Operating system: linux
>Description:
>
>Lot of idle connection created by "SET extra_float_digits = 3" which is
>killing our applicaiton.
>

SET extra_float_digits = 3 (or any other SET command) does not create any
connections at all. It's much more likely your application opens a new
connection, executes the SET command on it (so it's in pg_stat_activity)
and then goes to do something else.

If that's not the case, we need much more information. Why do you think
the SET command is creating idle connections?

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 anup singh 2019-04-16 12:01:42 Re: BUG #15759: Lot of idle connection created by "SET extra_float_digits = 3"
Previous Message PG Bug reporting form 2019-04-16 11:04:25 BUG #15759: Lot of idle connection created by "SET extra_float_digits = 3"