Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
Re: Hanging queries on Windows 2003 SP1
- From: "Wei Song" <weisong44(at)gmail(dot)com>
- To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
- Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
- Subject: Re: Hanging queries on Windows 2003 SP1
- Date: Mon, 4 Sep 2006 23:31:24 -0700
- Message-id: <13dc47610609042331y4646d191j1ee5fc4d83bc569b(at)mail(dot)gmail(dot)com>
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:
> 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
- References:
- Hanging queries on Windows 2003 SP1
- From: weisong44(at)gmail(dot)com
- Re: Hanging queries on Windows 2003 SP1
- From: Magnus Hagander
- Hanging queries on Windows 2003 SP1
- Prev by Date: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
- Next by Date: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
- Previous by thread: Re: Hanging queries on Windows 2003 SP1
- Next by thread: BUG #2606: (libpq) incorrect function declaration in libpq-fe.h
- Indexes: