Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 088219FBCC4
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 29 May 2007 17:43:56 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 23273-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 29 May 2007 17:43:51 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from developer.pgadmin.org (developer.pgadmin.org [63.246.23.140])
	by postgresql.org (Postfix) with ESMTP id 6EA869FBCBE
	for <pgsql-performance@postgresql.org>;
	Tue, 29 May 2007 17:43:51 -0300 (ADT)
Received: from snake.local ([89.243.125.113]) (authenticated bits=0)
	by developer.pgadmin.org (8.13.8/8.13.8) with ESMTP id l4TKSHp0015306
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Tue, 29 May 2007 20:28:19 GMT
Message-ID: <465C9082.3070607@postgresql.org>
Date: Tue, 29 May 2007 21:43:46 +0100
From: Dave Page <dpage@postgresql.org>
User-Agent: Thunderbird 2.0.0.0 (Macintosh/20070326)
MIME-Version: 1.0
To: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
CC: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Re: Vacuum takes forever
References: <1180458223.18930.16.camel@panoramix>
In-Reply-To: <1180458223.18930.16.camel@panoramix>
X-Enigmail-Version: 0.95.0
OpenPGP: url=http://www.pgadmin.org/pgp/davepage.pgp
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200705/587
X-Sequence-Number: 24977

Joost Kraaijeveld wrote:
> Hi 
> 
> I am currently running a vacuum analyse through PgAdmin on a PostgreSQL
> 8.1.9 database that takes forever without doing anything: no
> (noticeable) disk activity or (noticeable) CPU activity. 
> 
> The mesage tab in PgAdmin says:
> 
> ...
> Detail: 0 index pages have been deleted, 0 are currently reusable.
> CPU 0.01s/0.00u sec elapsed 568.16 sec
> ....
> 
> and lots of entries looking just like this ( 0 % CPU, > 500 secs).
> 
> There are no other connections to the database and the machine does not
> do anything else than me typing this e-mail and playing Metallica MP3's.

Cliff, Jason or Rob era? Could be important...

:-)

Regards, Dave.