Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id EADAC64FE3B
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 23 Dec 2008 08:01:51 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 66348-06
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 23 Dec 2008 08:01:49 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from lists.commandprompt.com (host-159.commandprompt.net
	[207.173.203.159])
	by mail.postgresql.org (Postfix) with ESMTP id 62E0364FE21
	for <pgsql-performance@postgresql.org>;
	Tue, 23 Dec 2008 08:01:48 -0400 (AST)
Received: from perhan.alvh.no-ip.org (190-95-20-64.bk17-dsl.surnet.cl
	[190.95.20.64]) (authenticated bits=0)
	by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id mBNC6MEP022312
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Tue, 23 Dec 2008 04:06:25 -0800
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id 0B1FF47CCE; Tue, 23 Dec 2008 09:01:07 -0300 (CLST)
Date: Tue, 23 Dec 2008 09:01:06 -0300
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Mark Wong <markwkm@gmail.com>
Cc: Gregory Stark <stark@enterprisedb.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>,
	Selena Deckelmann <selenamarie@gmail.com>,
	Gabrielle Roth <gorthx@gmail.com>
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Message-ID: <20081223120106.GC6217@alvh.no-ip.org>
References: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com>
	<87hc4yuxbl.fsf@oxford.xeocode.com>
	<552F108E-9732-4ED6-B45D-6C651C63565E@gmail.com>
	<87d4fkvgtj.fsf@oxford.xeocode.com>
	<70c01d1d0812220050kb1f755etea3ecada3f3b8631@mail.gmail.com>
	<871vw0v5ot.fsf@oxford.xeocode.com>
	<70c01d1d0812221936o57e54ec1j20b15309141672d5@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <70c01d1d0812221936o57e54ec1j20b15309141672d5@mail.gmail.com>
User-Agent: Mutt/1.5.18 (2008-05-17)
X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0
	(lists.commandprompt.com [207.173.203.159]);
	Tue, 23 Dec 2008 04:06:26 -0800 (PST)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200812/201
X-Sequence-Number: 32237

Mark Wong escribió:

> Hrm, tracking just the launcher process certainly doesn't help.  Are
> the spawned processed short lived?  I take a snapshot of
> /proc/<pid>/io data every 60 seconds.

The worker processes can be short-lived, but if they are, obviously they
are not vacuuming the large tables.  If you want to track all autovacuum
actions, change autovacuum_log_min_messages to 0.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support