Michael Fuhr <mike@xxxxxxxx> writes: > On Sat, Sep 03, 2005 at 11:31:19AM +0530, Mavinakuli, Prasanna (STSD) wrote: >> 1) I am using postgres 7.4 version. > Exactly which version? I'm wondering about the relevance of this pre-7.4-final bug fix: 2003-10-19 17:36 tgl * src/interfaces/libpq/: fe-exec.c, fe-misc.c: Adjust libpq to avoid deadlock when both client and server want to send data, and both have filled the transmission buffers. One scenario where this can happen was illustrated here: http://archives.postgresql.org/pgsql-hackers/2003-04/msg00979.php Supposing that a 7.4-beta libpq were in use, and for some reason the server tries to send a large reply message before it's absorbed all of the command, we could see a hangup like this. It'd be useful to see an strace of the server process in parallel with the client. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
