| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Orphaned statements issue |
| Date: | 2011-01-20 23:28:36 |
| Message-ID: | 4D38C524.20001@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 1/20/11 2:26 PM, Tom Lane wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
>>> I would take that to mean that it's waiting on the client.
>
>> You mean that the client timed out and isn't accepting data from the
>> query anymore?
>
> No, if the backend is in RECV state, it's waiting for the client to
> *send* it something.
I don't think that's consistent with what we're seeing except maybe in
the <BIND> case. In the other cases, there's a query supposedly
executing. But, will look for that possibility.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-01-20 23:34:35 | Re: One Role, Two Passwords |
| Previous Message | Kevin Grittner | 2011-01-20 23:28:30 | Re: SSI and Hot Standby |