Skip site navigation (1) Skip section navigation (2)

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: 2006-09-05 06:31:24
Message-ID: 13dc47610609042331y4646d191j1ee5fc4d83bc569b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-performance
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
>

In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2006-09-05 13:31:59
Subject: Re: increasing shared buffers: how much should be removed
Previous:From: Indika MaligaspeDate: 2006-09-05 04:02:04
Subject: Re: Postgress memory leak with JBoss3.2.6 and large DB

pgsql-bugs by date

Next:From: Volkan YAZICIDate: 2006-09-05 08:19:42
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous:From: Devrim GUNDUZDate: 2006-09-04 19:51:12
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group