X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 41DE9D9E1C for ; Mon, 3 Oct 2005 18:32:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41954-03 for ; Mon, 3 Oct 2005 21:32:06 +0000 (GMT) Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by svr1.postgresql.org (Postfix) with ESMTP id 50D52D9E0E for ; Mon, 3 Oct 2005 18:32:06 -0300 (ADT) Received: from 192.168.0.3 (unknown [84.12.188.233]) by smtp.nildram.co.uk (Postfix) with ESMTP id 2600E250159; Mon, 3 Oct 2005 22:32:04 +0100 (BST) Subject: Re: Vacuum Full Analyze Stalled From: Simon Riggs To: Tom Lane Cc: Alvaro Herrera , "Jim C. Nasby" , Kevin Grittner , Jeff Kirby , pgsql-admin@postgresql.org In-Reply-To: <14993.1128372520@sss.pgh.pa.us> References: <20051003194114.GD40138@pervasive.com> <20051003201225.GA11527@surnet.cl> <14993.1128372520@sss.pgh.pa.us> Content-Type: text/plain Organization: 2nd Quadrant Date: Mon, 03 Oct 2005 22:32:25 +0100 Message-Id: <1128375145.8603.128.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.069 required=5 tests=[AWL=0.019, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200510/42 X-Sequence-Number: 19114 On Mon, 2005-10-03 at 16:48 -0400, Tom Lane wrote: > Finally, I'm wondering whether this bug is new in 8.1 or is > pre-existing. Has this same application been running successfully > in 8.0? My money would be on a pre-existing bug. I recall two cases of unexplained VACUUM hang in the last year. Best Regards, Simon Riggs