Hi, We are seeing hanging queries on Windows 2003 Server SP1 with dual CPU, looks like one of the process is blocked. In a lot of cases, the whole DB is blocked if this process is holding important locks.
Looks like this issue was discussed in the following thread a few month ago, but didn't seem to have a solution mention. I would liek to know if there is a patch for this already? http://archives.postgresql.org/pgsql-performance/2006-03/msg00129.php I would appreciate your feedbaek, Thanks, Wei ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly