From: Jim C. Nasby <jim@nasby.net>
To: Medora Schauer <mschauer@fairfield.com>
Cc: Bill Moran <wmoran@collaborativefusion.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: autovacuum not working?
Date: Mon, 9 Oct 2006 16:26:15 -0500
Message-ID: <20061009212615.GN72517@nasby.net> (raw)
In-Reply-To: <1CA058827877644DAB54FB930FFA3B05D89F73@lincoln.FAIRIND.FAIRFIELD.COM>
References: <1CA058827877644DAB54FB930FFA3B05D89F73@lincoln.FAIRIND.FAIRFIELD.COM>
On Mon, Oct 09, 2006 at 09:27:30AM -0500, Medora Schauer wrote:
> > From your attached config file:
> >
> > #autovacuum_vacuum_threshold = 1000 # min # of tuple updates before
> > # vacuum
> >
>
> Yup, that was it.
Actually, not quite.
Vacuum will update relpages and reltuples, but it won't update other
stats. That's what analyze does (autovacuum_analyze_threshold). By
default, that's set to 500; I'll typically drop it to 200 or so (keep in
mind that analyze is much cheaper than vacuum).
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jim@nasby.net, mschauer@fairfield.com, wmoran@collaborativefusion.com
Subject: Re: autovacuum not working?
In-Reply-To: <20061009212615.GN72517@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox