X-Original-To: pgsql-bugs-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 749C19FB209
	for <pgsql-bugs-postgresql.org@postgresql.org>;
	Tue,  5 Sep 2006 03:31:30 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 81324-08 for <pgsql-bugs-postgresql.org@postgresql.org>;
	Tue,  5 Sep 2006 03:31:26 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.227])
	by postgresql.org (Postfix) with ESMTP id CFA3E9FB205
	for <pgsql-bugs@postgresql.org>; Tue,  5 Sep 2006 03:31:26 -0300 (ADT)
Received: by qb-out-0506.google.com with SMTP id e11so509317qba
	for <pgsql-bugs@postgresql.org>; Mon, 04 Sep 2006 23:31:26 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=UPXzlXLTxffo/tB69mrnlRmxsQ0MXvyhRVDdBW/cu5YqT8huADx4iIH4TKO+bfg/PPe2SbKEv32PCpdsgYk5E5LeZKXyrJxCl7mre/a2dN4M5k9ff1fquQTklWVDpNStfoVlUQY17+DV+AFsU7fAFqAJ+1B2cTUUuJznGvCzMZ8=
Received: by 10.90.79.6 with SMTP id c6mr1212116agb;
	Mon, 04 Sep 2006 23:31:25 -0700 (PDT)
Received: by 10.90.106.7 with HTTP; Mon, 4 Sep 2006 23:31:24 -0700 (PDT)
Message-ID: <13dc47610609042331y4646d191j1ee5fc4d83bc569b@mail.gmail.com>
Date: Mon, 4 Sep 2006 23:31:24 -0700
From: "Wei Song" <weisong44@gmail.com>
To: "Magnus Hagander" <mha@sollentuna.net>
Subject: Re: Hanging queries on Windows 2003 SP1
Cc: pgsql-bugs@postgresql.org, pgsql-performance@postgresql.org
In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA3561C@algol.sollentuna.se>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_118540_16090014.1157437884576"
References: <1157147780.568274.141690@e3g2000cwe.googlegroups.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA3561C@algol.sollentuna.se>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.932 tagged_above=0 required=5 tests=HTML_30_40,
	HTML_MESSAGE, RCVD_IN_BL_SPAMCOP_NET, SPF_PASS
X-Spam-Level: *
X-Archive-Number: 200609/31
X-Sequence-Number: 15707

------=_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@sollentuna.net> wrote:
>
> > 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
> >
>
> 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
>

------=_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@sollentuna.net">mha@sollentuna.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>
&gt; <a href="http://archives.postgresql.org/pgsql-performance/2006-">http://archives.postgresql.org/pgsql-performance/2006-</a><br>&gt; 03/msg00129.php<br>&gt;<br><br>There have been some fairly extensive changes in the semaphore code for
<br>8.2. Any chance you can try the cvs snapshot version and see if the<br>problem exists there as well?<br><br>//Magnus<br></blockquote></div><br>

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