Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id DDCB3632D47
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 28 Apr 2010 11:46:19 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 89436-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 28 Apr 2010 14:46:08 +0000 (UTC)
Received: from mx2.hub.org (mx2.hub.org [200.46.204.254])
	by mail.postgresql.org (Postfix) with ESMTP id 2F25D6324B1
	for <pgsql-performance@postgresql.org>;
	Wed, 28 Apr 2010 11:46:10 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mh3.mail.rice.edu (mh3.mail.rice.edu [128.42.199.10])
	by mx2.hub.org (Postfix) with ESMTP id 610A23EABBE0
	for <pgsql-performance@postgresql.org>;
	Wed, 28 Apr 2010 11:46:08 -0300 (ADT)
Received: from mh3.mail.rice.edu (localhost.localdomain [127.0.0.1])
	by mh3.mail.rice.edu (Postfix) with ESMTP id A736332400D;
	Wed, 28 Apr 2010 09:45:37 -0500 (CDT)
X-Virus-Scanned: by amavis-2.6.0 at mh3.mail.rice.edu
Received: from mh3.mail.rice.edu ([127.0.0.1])
	by mh3.mail.rice.edu (mh3.mail.rice.edu [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id QsdJAnwsJf6v; Wed, 28 Apr 2010 09:45:37 -0500 (CDT)
Received: from aart.is.rice.edu (aart.is.rice.edu [168.7.56.48])
	by mh3.mail.rice.edu (Postfix) with ESMTP id 7B9FA432532;
	Wed, 28 Apr 2010 09:45:37 -0500 (CDT)
Received: by aart.is.rice.edu (Postfix, from userid 18612)
	id 4AA5B2D5A1; Wed, 28 Apr 2010 09:45:37 -0500 (CDT)
Date: Wed, 28 Apr 2010 09:45:36 -0500
From: Kenneth Marshall <ktm@rice.edu>
To: akp geek <akpgeek@gmail.com>
Cc: Thomas Kellerer <spam_eater@gmx.net>, pgsql-performance@postgresql.org
Subject: Re: autovacuum strategy / parameters
Message-ID: <20100428144536.GC1610@aart.is.rice.edu>
References: <c2d2b6cf-895f-4a4b-aa8b-3adaac33c794@z3g2000yqz.googlegroups.com>
	<y2g603c8f071004221155h3874a3c0ybbe2c790e3c1bf80@mail.gmail.com>
	<65d9d15d-41d2-4bfa-8cc3-6148b4fb9022@z3g2000yqz.googlegroups.com>
	<hr9g84$at8$1@dough.gmane.org>
	<x2o2024a9fb1004280737gb35a3065uad2e6007bdff1993@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <x2o2024a9fb1004280737gb35a3065uad2e6007bdff1993@mail.gmail.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201004/330
X-Sequence-Number: 38580

Check out the manual:

http://www.postgresql.org/docs/8.4/static/routine-vacuuming.html#AUTOVACUUM

Cheers,
Ken

On Wed, Apr 28, 2010 at 10:37:35AM -0400, akp geek wrote:
> Hi -
>            don't want to side track the discussion. We have 8.4, which of
> AUTOVACUUM PARAMETERS can be set to handle individual table?  I ran into
> bloat with small table only. Now the issue is being resolved.
> 
> Regards
> On Wed, Apr 28, 2010 at 10:20 AM, Thomas Kellerer <spam_eater@gmx.net>wrote:
> 
> > Rick, 22.04.2010 22:42:
> >
> >
> >> So, in a large table, the scale_factor is the dominant term. In a
> >> small table, the threshold is the dominant term. But both are taken into
> >> account.
> >>
> >> The default values are set for small tables; it is not being run for
> >> large tables.
> >>
> >
> > With 8.4 you can adjust the autovacuum settings per table...
> >
> >
> >
> >
> >
> > --
> > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-performance
> >