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 AA1C99DCADA for ; Fri, 10 Mar 2006 15:37:20 -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 33543-08 for ; Fri, 10 Mar 2006 15:37:20 -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 B30CD9DC999 for ; Fri, 10 Mar 2006 15:37:16 -0400 (AST) Received: from toronto.toronto.digitalfairway.ca (unknown [192.168.100.10]) by mail.digitalfairway.ca (Postfix) with ESMTP id 8A3EDA0631 for ; Fri, 10 Mar 2006 14:37:17 -0500 (EST) Received: from localhost (toronto.toronto.digitalfairway.ca [127.0.0.1]) by toronto.toronto.digitalfairway.ca (Postfix) with ESMTP id 7A255124D0E for ; Fri, 10 Mar 2006 14:37:17 -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 06037-01 for ; Fri, 10 Mar 2006 14:37:17 -0500 (EST) Received: from [192.168.100.50] (unknown [192.168.100.50]) (using SSLv3 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by toronto.toronto.digitalfairway.ca (Postfix) with ESMTP id 60337124D0D for ; Fri, 10 Mar 2006 14:37:17 -0500 (EST) From: Jan de Visser To: pgsql-performance@postgresql.org Subject: Re: Hanging queries on dual CPU windows Date: Fri, 10 Mar 2006 14:37:13 -0500 User-Agent: KMail/1.9.1 References: <6BCB9D8A16AC4241919521715F4D8BCEA0F847@algol.sollentuna.se> <200603101427.40357.jdevisser@digitalfairway.com> In-Reply-To: <200603101427.40357.jdevisser@digitalfairway.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200603101437.14902.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.09 required=5 tests=[AWL=0.090] X-Spam-Score: 0.09 X-Spam-Level: X-Archive-Number: 200603/143 X-Sequence-Number: 17580 On Friday 10 March 2006 14:27, Jan de Visser wrote: > As a BTW: I reinstalled SP1 and turned stats collection off. That also > seems to work, but is not really a solution since we want to use > autovacuuming. I lied. I hangs now. Just takes a lot longer... jan =2D-=20 =2D------------------------------------------------------------- Jan de Visser =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 jdevisser@digitalfair= way.com =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Baruk Khazad! Khazad ai-menu! =2D-------------------------------------------------------------