pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Hanging queries on Windows 2003 SP1
3+ messages / 3 participants
[nested] [flat]

* Hanging queries on Windows 2003 SP1
@ 2006-09-01 21:56 weisong44@gmail.com <weisong44@gmail.com>
  2006-09-04 11:39 ` Re: Hanging queries on Windows 2003 SP1 Magnus Hagander <mha@sollentuna.net>
  0 siblings, 1 reply; 3+ messages in thread

From: weisong44@gmail.com @ 2006-09-01 21:56 UTC (permalink / raw)
  To: pgsql-bugs@postgresql.org

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

I would appreciate your feedbaek,

Thanks,
Wei




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Hanging queries on Windows 2003 SP1
  2006-09-01 21:56 Hanging queries on Windows 2003 SP1 weisong44@gmail.com <weisong44@gmail.com>
@ 2006-09-04 11:39 ` Magnus Hagander <mha@sollentuna.net>
  2006-09-05 06:31   ` Re: Hanging queries on Windows 2003 SP1 Wei Song <weisong44@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Magnus Hagander @ 2006-09-04 11:39 UTC (permalink / raw)
  To: weisong44@gmail.com; pgsql-bugs@postgresql.org; pgsql-performance

> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Hanging queries on Windows 2003 SP1
  2006-09-01 21:56 Hanging queries on Windows 2003 SP1 weisong44@gmail.com <weisong44@gmail.com>
  2006-09-04 11:39 ` Re: Hanging queries on Windows 2003 SP1 Magnus Hagander <mha@sollentuna.net>
@ 2006-09-05 06:31   ` Wei Song <weisong44@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Wei Song @ 2006-09-05 06:31 UTC (permalink / raw)
  To: Magnus Hagander <mha@sollentuna.net>; +Cc: pgsql-bugs@postgresql.org; pgsql-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@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
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-09-05 06:31 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-01 21:56 Hanging queries on Windows 2003 SP1 weisong44@gmail.com <weisong44@gmail.com>
2006-09-04 11:39 ` Magnus Hagander <mha@sollentuna.net>
2006-09-05 06:31   ` Wei Song <weisong44@gmail.com>

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