Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 993AD632F8A
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 12 Nov 2009 11:14:29 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 73579-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 12 Nov 2009 15:14:10 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iw0-f182.google.com (mail-iw0-f182.google.com
	[209.85.223.182])
	by mail.postgresql.org (Postfix) with ESMTP id B3059632DF6
	for <pgsql-performance@postgresql.org>;
	Thu, 12 Nov 2009 11:14:18 -0400 (AST)
Received: by iwn12 with SMTP id 12so1725121iwn.15
	for <pgsql-performance@postgresql.org>;
	Thu, 12 Nov 2009 07:14:17 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=COYPIP0Fz5ubJhdF5k+Ve5ryU6Qxx/C7I8Kkpim0q58=;
	b=eHKBHM04g5vDJMgifrY3nYvc+V3fj1M/sBTtKCuMXCfHTBsYTvn3rQsqIqGRWr7k2x
	y5Vpn/b21VIp+3rlRYly13qdIs5zDW3EEF1OOn9AI4dO9AAZH2EjV//3UfhPFoPZ/oxW
	pdkqEst606DoFXiOOkfjZ4mIYzrQKz1hcSv2s=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=ub3WkFGfBxZuSb4fzWp9nHvelmDNBkL26o5fWguAfUbH768MhA2rVpWiFH9pohLkKc
	Ac7nNzCGedRpv3VJDrPpwOiVMtkkz0LgLusQuPD3qnZMYsIzVEgybgMZISH0amWHi7Jn
	YqnJB0RCAIGlC+Kgs4boaGN3ml4rGjFFzKbsI=
MIME-Version: 1.0
Received: by 10.231.48.210 with SMTP id s18mr2494752ibf.3.1258038857051; Thu,
	12 Nov 2009 07:14:17 -0800 (PST)
In-Reply-To: <20091112093301.11953uc4r7pgqzy8@www.aceinnovative.com>
References: <20091112093301.11953uc4r7pgqzy8@www.aceinnovative.com>
Date: Thu, 12 Nov 2009 08:14:17 -0700
Message-ID: <dcc563d10911120714i5e24e1das20f13a0cdc348dee@mail.gmail.com>
Subject: Re: Manual vacs 5x faster than autovacs?
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Wayne Beaver <wayne@acedsl.com>
Cc: pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.504 tagged_above=-10 required=5 tests=AWL=0.095,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200911/125
X-Sequence-Number: 36293

On Thu, Nov 12, 2009 at 7:33 AM, Wayne Beaver <wayne@acedsl.com> wrote:
> Hi All,
>
> Running Pg 8.3RC2, Linux server, w/8GB RAM, OpenSuSE 10.2 OS (yes, I know
> that's old). I have seen *really* long-running autovacs eating up system
> resources. While the below is not an example of *really* long, it shows how
> I killed an autovac which had been running for more than 10 minutes, then
> ran a VAC FULL ANALYZE on same exact table in about ~2 min. Any wisdom here?
> Attributable to autovac_worker settings? Or Pg version? Other?
>
> Any insight appreciated.

Autovac running slow is (generally) a good thing.  It reduces the load
on your IO subsystem so that other queries can still run fast.  What
resources are your long running autovacs eating up.  If top shows
500Mres and 499Mshr, then don't worry, it's not actually eating up
resources.