From: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
---|---|
To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Handling idle connections |
Date: | 2023-09-27 10:32:41 |
Message-ID: | CAJk5AtZD7Zo7kLLbRcHJg5cKWu6YVymfPt=qVUdpt6SMyXR-Wg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you.
I am planning to use pgbouncer. Help me with the configuration of
pgbouncer. Do I have to increase max_connections in postgres.conf when we
r configuring pg_bouncer? Help me with pgbouncer configuration or links
that is very clear.
On Tue, 26 Sep, 2023, 8:38 PM Scott Ribe, <scott_ribe(at)elevated-dev(dot)com>
wrote:
> > I am assuming like tell them "check sessions are closed properly" like
> dat?
>
> Don't open until needed, close when done. Assuming they're actually a
> problem--for smaller scale environments, it can be perfectly OK to have
> clients holding connections open for the entire client lifetime.
>
> Set application name on connection, so that *if* there is a problem it's
> easier to track down.
>
> > On Sep 26, 2023, at 8:55 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> >
> > You haven't answered my question. If "query" is truly blank and it is
> not just a permission problem, then the issue is not that they fail to
> close connections after use, but rather that they open connections and then
> never use them.
>
> Which could easily be a matter of some pg library being used. As far as I
> see, there was also never an answer to whether this is actually a problem
> and if so, how?
>
> And one more: if there is a problem, why not use pgbouncer?
>
> We've given all the information we can about how to identify such
> connections. Any further help would depend on more info from Rajesh.
From | Date | Subject | |
---|---|---|---|
Next Message | Deo Felix | 2023-09-27 13:25:20 | Terminating connection because of crash of another server process |
Previous Message | Daulat | 2023-09-27 09:11:12 | Re: Upgrade postgres 14.6 to minor version using source code |