Re: Pgbouncer - Mailing list pgsql-general

From Torsten Förtsch
Subject Re: Pgbouncer
Date
Msg-id 565CC621.5090108@gmx.net
Whole thread Raw
In response to Re: Pgbouncer  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
On 30/11/15 22:50, Steve Crawford wrote:
> Do you have any clients connected that are idle in transaction?

No, the backend database is a streaming replica. Also, as I said, the
backend process is in "idle" state not "idle in transaction".

backend_start    | 2015-11-30 18:58:30.639962+00
xact_start       | <NULL>
query_start      | 2015-11-30 20:56:36.479003+00
state_change     | 2015-11-30 20:56:36.480199+00
waiting          | f
state            | idle



pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Pgbouncer
Next
From: "Steve Petrie, P.Eng."
Date:
Subject: Re: using a postgres table as a multi-writer multi-updater queue