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.
Are there any tools I can use to figure out what's going on with the client/server? pgmonitor doesn't give any additional information (except ``no query is being executed''). Regards, -- Raju -- Raj Mathur [EMAIL PROTECTED] http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F All your domain are belong to us. It is the mind that moves ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
