Re: Ned to understand why all the idle connections

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 a

Re: Ned to understand why all the idle connections

ecommend using PgBouncer with JDBC? - Si Chen Open Source Strategies, Inc. Our Mission: https://www.youtube.com/watch?v=Uc7lmvnuJHY On Thu, Apr 23, 2020 at 11:41 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thursday, April 23, 2020, David Gauthier > wrote: > >

relationship of backend_start, query_start, state_change

been around since 1 AM and the last query is always "COMMIT"? Or should we keep it open because the query_start keeps updating, and the state_change is basically keeping up with query_start? - Si Chen Open Source Strategies, Inc. Our Mission: https://www.youtube.com/watch?v=Uc7lmvnuJHY