Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 1C6E8B5DBBE
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 12 Jun 2011 00:55:12 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 26537-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 12 Jun 2011 03:55:04 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f46.google.com (mail-bw0-f46.google.com
	[209.85.214.46])
	by mail.postgresql.org (Postfix) with ESMTP id 7D3DAB5DBC6
	for <pgsql-performance@postgresql.org>;
	Sun, 12 Jun 2011 00:55:04 -0300 (ADT)
Received: by bwz15 with SMTP id 15so3016796bwz.19
	for <pgsql-performance@postgresql.org>;
	Sat, 11 Jun 2011 20:55:03 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:in-reply-to:references:date
	:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=iYjIgkDtfMmo9iEyjR2iuAWETdpmtHuWhBSaJXybmqs=;
	b=jUn0DLeYTbevK3Q2ASgx6O3KGGovMVQUJ+XmUcOk4Hf9qmbIiPSpLLCFoG2KKWnP7D
	FG1Zu5oamjULM52v2169RCckOFpg71/o0mA5bKBQAzPsHKd4zof2TJwT50ZebB1QhqXg
	Y9maQCv88YFo0QQGIZzUbvlmSo4MOAgu96/EU=
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:content-transfer-encoding;
	b=aqpD2JyQ1B0dAyJloyTFXSlR2jSWEjkDdRJFue6i1gKy5/qXwaatNc/ObNUls2P44p
	21YjV9uQXEzQrMVksx6jkVtbbYERBn7bPnNHs4Lvw3KsPhbNwdEOQVVXo2QNQTXVRwz6
	6HmV7DhQB317YquN2w5syvV1272s3l/qhz7oE=
MIME-Version: 1.0
Received: by 10.204.84.27 with SMTP id h27mr1402086bkl.158.1307850903522; Sat,
	11 Jun 2011 20:55:03 -0700 (PDT)
Received: by 10.204.40.8 with HTTP; Sat, 11 Jun 2011 20:55:03 -0700 (PDT)
In-Reply-To: <4DF3EE47.2040308@lerner.co.il>
References: <4DF0E5A0.7080101@lerner.co.il> <4DF0FA36.2010802@2ndquadrant.com>
	<4DF3EE47.2040308@lerner.co.il>
Date: Sat, 11 Jun 2011 21:55:03 -0600
Message-ID: <BANLkTimQL2KVS=MaePCGOvjnATxsWTdH3w@mail.gmail.com>
Subject: Re: Triggering autovacuum
From: Scott Marlowe <scott.marlowe@gmail.com>
To: "Reuven M. Lerner" <reuven@lerner.co.il>
Cc: Greg Smith <greg@2ndquadrant.com>, pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001
X-Spam-Level: 
X-Archive-Number: 201106/129
X-Sequence-Number: 44062

On Sat, Jun 11, 2011 at 4:37 PM, Reuven M. Lerner <reuven@lerner.co.il> wro=
te:
> Hi, Greg. =A0Thanks for the quick and useful answer, even if it means tha=
t my
> hopes for a quick fix have been dashed. =A0I guess I'll need to do some a=
ctual
> monitoring, then...

You mention pg_stat_user_tables, what did the last_analyze column for
those tables say?