> 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? Shouldn't Postgres time out on that after a while? In
one case, the orphaned statement was 16 hours old before we killed it.
If it's relevant, the client connection is from a C application via
libpq on localhost.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com