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...3/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 majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

There have been some fairly extensive changes in the semaphore code for
8.2. Any chance you can try the cvs snapshot version and see if the
problem exists there as well?

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

------=_Part_118540_16090014.1157437884576
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Magnus,

Sure, I could try that out. Is there a place to download a 8.2 image to
bypass setting up the tool chain?

-Wei


On 9/4/06, Magnus Hagander <mha (AT) sollentuna (DOT) net> wrote:
------=_Part_118540_16090014.1157437884576
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Magnus,<br><br>Sure, I could try that out. Is there a place to download a 8.2 image to bypass setting up the tool chain?<br><br>-Wei<br><br><br><div><span class="gmail_quote">On 9/4/06, <b class="gmail_sendername">Magnus Hagander
</b> &lt;<a href="mailto:mha (AT) sollentuna (DOT) net">mha (AT) sollentuna (DOT) net</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">&gt; Hi,
<br>&gt;<br>&gt; We are seeing hanging queries on Windows 2003 Server SP1 with dual<br>&gt; CPU, looks like one of the process is blocked. In a lot of cases,<br>&gt; the whole DB is blocked if this process is holding important locks.
<br>&gt;<br>&gt; Looks like this issue was discussed in the following thread a few<br>&gt; month ago, but didn't seem to have a solution mention. I would liek<br>&gt; to know if there is a patch for this already?<br>&gt;<br>

------=_Part_118540_16090014.1157437884576--