Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 692749FB81E
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 29 May 2007 14:03:59 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 77366-05 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Tue, 29 May 2007 14:03:53 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id DA39F9FB6BC
	for <pgsql-performance@postgresql.org>;
	Tue, 29 May 2007 14:03:54 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16])
	by svr4.postgresql.org (Postfix) with ESMTP id 0DEF15AF039
	for <pgsql-performance@postgresql.org>;
	Tue, 29 May 2007 17:03:53 +0000 (GMT)
Received: obelix 172.31.0.1 from 172.31.1.1 172.31.1.1 via HTTP with
	MS-WebStorage 6.0.6249
Received: from panoramix by obelix; 29 May 2007 19:03:43 +0200
Subject: Vacuum takes forever
From: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
To: postgresql performance list <pgsql-performance@postgresql.org>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: Tue, 29 May 2007 19:03:43 +0200
Message-Id: <1180458223.18930.16.camel@panoramix>
Mime-Version: 1.0
X-Mailer: Evolution 2.6.3 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.171 tagged_above=0 required=5 tests=AWL=0.034,
	BAYES_50=0.001, FORGED_RCVD_HELO=0.135, UNPARSEABLE_RELAY=0.001
X-Spam-Level: 
X-Archive-Number: 200705/583
X-Sequence-Number: 24973

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.

Could this be because of my Cost-Based Vacuum Delay settings ?

vacuum_cost_delay = 200
vacuum_cost_page_hit = 6
#vacuum_cost_page_miss = 10             # 0-10000 credits
#vacuum_cost_page_dirty = 20            # 0-10000 credits
vacuum_cost_limit = 100



-- 
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl