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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Hanging queries on Windows 2003 SP1


  • From: "weisong44(at)gmail(dot)com" <weisong44(at)gmail(dot)com>
  • To: pgsql-bugs(at)postgresql(dot)org pgsql-performance(at)postgresql(dot)org
  • Subject: Hanging queries on Windows 2003 SP1
  • Date: 1 Sep 2006 14:56:20 -0700
  • Message-id: <1157147780(dot)568274(dot)141690(at)e3g2000cwe(dot)googlegroups(dot)com>

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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group