Thanks for answering my questions.
Sorry I didn't mean to "top post" I thought that my other email got lost
because I had sent it to lists.postgresql.org
-
Si Chen
Open Source Strategies, Inc.
Our Mission: https://www.youtube.com/watch?v=Uc7lmvnuJHY
On Thu, Apr 23, 2020 at 2:31 PM David
Please don't top-post; and this is a fairly rude hijack posting given that
you already have a thread going, from today no less, where you've basically
asked this very same question.
On Thu, Apr 23, 2020 at 2:18 PM Si Chen
wrote:
> Hello David & David,
>
> I have a similar problem -- a lot of idl
Hello David & David,
I have a similar problem -- a lot of idle transactions. I'm using the
PostgreSQL JDBC driver. The connections look like this:
pid | wait_event | state_change |
backend_start | xact_start | query_start |
?column? | query
On Thu, Apr 23, 2020 at 11:52 AM David Gauthier
wrote:
> Thanks!
> And an example of connection pooling is pgBouncer ?
>
>>
>>
It does describe itself as being a "Lightweight connection pooler for
PostgreSQL" ...
https://www.pgbouncer.org/
David J.
Thanks!
And an example of connection pooling is pgBouncer ?
On Thu, Apr 23, 2020 at 2:41 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thursday, April 23, 2020, David Gauthier
> wrote:
>
>> Hi:
>>
>> psql (9.6.7, server 11.3) on linux
>>
>> I have what appear to be a log of idl
On Thursday, April 23, 2020, David Gauthier
wrote:
> Hi:
>
> psql (9.6.7, server 11.3) on linux
>
> I have what appear to be a log of idle connections to my DB. Query of
> pg_stat_activity indicates well over half (127/206) are like this...
>
>
> dvdb=# select state_change,wait_event_type,wait_e
Hi:
psql (9.6.7, server 11.3) on linux
I have what appear to be a log of idle connections to my DB. Query of
pg_stat_activity indicates well over half (127/206) are like this...
dvdb=# select state_change,wait_event_type,wait_event,state,backend_type
from pg_stat_activity where query = '';
