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