From: Wei Song <weisong44@gmail.com>
To: Magnus Hagander <mha@sollentuna.net>
Cc: pgsql-bugs@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Hanging queries on Windows 2003 SP1
Date: Mon, 4 Sep 2006 23:31:24 -0700
Message-ID: <13dc47610609042331y4646d191j1ee5fc4d83bc569b@mail.gmail.com> (raw)
In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCEA3561C@algol.sollentuna.se>
References: <1157147780.568274.141690@e3g2000cwe.googlegroups.com>
<6BCB9D8A16AC4241919521715F4D8BCEA3561C@algol.sollentuna.se>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: weisong44@gmail.com, mha@sollentuna.net, pgsql-bugs@postgresql.org
Subject: Re: Hanging queries on Windows 2003 SP1
In-Reply-To: <13dc47610609042331y4646d191j1ee5fc4d83bc569b@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox