| From: | Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net> |
|---|---|
| To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Pgbouncer |
| Date: | 2015-11-30 21:56:49 |
| Message-ID: | 565CC621.5090108@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Petrie, P.Eng. | 2015-12-01 04:07:36 | Re: using a postgres table as a multi-writer multi-updater queue |
| Previous Message | Steve Crawford | 2015-11-30 21:50:51 | Re: Pgbouncer |