Raj Mathur <raju(at)linux-delhi(dot)org> writes:
> I'm consistently getting into a situation where the database client
> just goes to sleep in a query after some number of queries in quick
> succession. Using PostgreSQL 7.2.3 on Red Hat Linux 8.0. The
> postgres process shows up as ``idle in transaction'' in a ps.
In that case, the backend is waiting for input from the client.
If the client thinks it is waiting for the backend, I'd wonder about a
missing "fflush" or something like that. What client software are you
using?
regards, tom lane