X-Original-To: pgsql-bugs-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 21ADC9FB492; Fri, 1 Sep 2006 19:50:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 48404-06-2; Fri, 1 Sep 2006 19:48:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id E35B99FB72F; Fri, 1 Sep 2006 18:56:28 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id D8D95308E6; Fri, 1 Sep 2006 23:56:27 +0200 (MET DST) From: "weisong44@gmail.com" X-Newsgroups: pgsql.performance,pgsql.bugs Subject: Hanging queries on Windows 2003 SP1 Date: 1 Sep 2006 14:56:20 -0700 Organization: http://groups.google.com Lines: 17 Message-ID: <1157147780.568274.141690@e3g2000cwe.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.6) Gecko/20060728 Firefox/1.5.0.6,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: e3g2000cwe.googlegroups.com; posting-host=171.69.69.228; posting-account=Q2r5qg0AAABoCUxgx_Uyibx16xbfGOxg To: pgsql-bugs@postgresql.org pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/9 X-Sequence-Number: 15685 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