X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 020179DC807 for ; Thu, 9 Mar 2006 22:00:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30069-04 for ; Thu, 9 Mar 2006 22:00:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.digitalfairway.ca (ns.digitalfairway.ca [207.164.133.170]) by postgresql.org (Postfix) with ESMTP id D16A69DCA74 for ; Thu, 9 Mar 2006 22:00:24 -0400 (AST) Received: from toronto.toronto.digitalfairway.ca (unknown [192.168.100.10]) by mail.digitalfairway.ca (Postfix) with ESMTP id C4C7DA068D for ; Thu, 9 Mar 2006 21:00:28 -0500 (EST) Received: from localhost (toronto.toronto.digitalfairway.ca [127.0.0.1]) by toronto.toronto.digitalfairway.ca (Postfix) with ESMTP id 7920812403D for ; Thu, 9 Mar 2006 21:00:28 -0500 (EST) Received: from toronto.toronto.digitalfairway.ca ([127.0.0.1]) by localhost (toronto.toronto.digitalfairway.ca [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09198-05 for ; Thu, 9 Mar 2006 21:00:28 -0500 (EST) Received: from whitby.toronto.digitalfairway.ca (unknown [192.168.100.153]) (using SSLv3 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by toronto.toronto.digitalfairway.ca (Postfix) with ESMTP id 50A8B124039 for ; Thu, 9 Mar 2006 21:00:28 -0500 (EST) From: Jan de Visser To: pgsql-performance@postgresql.org Subject: Re: Hanging queries on dual CPU windows Date: Thu, 9 Mar 2006 21:00:27 -0500 User-Agent: KMail/1.9.1 References: <200603060938.00751.jdevisser@digitalfairway.com> <200603091507.04663.jdevisser@digitalfairway.com> <27202.1141935043@sss.pgh.pa.us> In-Reply-To: <27202.1141935043@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200603092100.27527.jdevisser@digitalfairway.com> X-Virus-Scanned: amavisd-new at digitalfairway.ca X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.086 required=5 tests=[AWL=0.086] X-Spam-Score: 0.086 X-Spam-Level: X-Archive-Number: 200603/103 X-Sequence-Number: 17540 On Thursday 09 March 2006 15:10, Tom Lane wrote: > Is it possible to get a stack trace from the stuck process? =C2=A0I dunno > if you've got anything gdb-equivalent under Windows, but that's the > first thing I'd be interested in ... Here ya go: http://www.devisser-siderius.com/stack1.jpg http://www.devisser-siderius.com/stack2.jpg http://www.devisser-siderius.com/stack3.jpg There are three threads in the process. I guess thread 1 (stack1.jpg) is th= e=20 most interesting. I also noted that cranking up concurrency in my app reproduces the problem = in=20 about 4 minutes ;-) With thanks to Magnus Hagander for the Process Explorer hint. jan =2D-=20 =2D------------------------------------------------------------- Jan de Visser =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 jdevisser@digitalfairway.com =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Baruk Khazad! Khaza= d ai-menu! =2D-------------------------------------------------------------