From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Henry Francisco Garcia Cortez <garcortez@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor
Date: Thu, 07 Jan 2021 02:53:31 +0100
Message-ID: <38c4371df337331ce4c8d97c3ea1ecce30fc4988.camel@cybertec.at> (raw)
In-Reply-To: <CAJP2v3G0S4pRGKDb6vNZuiU+N6TFhXXruLCQeTyJEBAV42CJ3g@mail.gmail.com>
References: <CAJP2v3G0S4pRGKDb6vNZuiU+N6TFhXXruLCQeTyJEBAV42CJ3g@mail.gmail.com>
On Wed, 2021-01-06 at 11:05 -0600, Henry Francisco Garcia Cortez wrote:
> I have a question why settings default postgresql has autovacuum_vacuum_scale_factor in 0.2
> is higher than autovacuum_analyze_scale_factor 0.1, so If want to tune these parameters,
> I always must leave autovacuum_vacuum_scale_factor higher than autovacuum_analyze_scale_factor,
> for instance I wanted to leave autovacuum_vacuum_scale_factor in 0.002 and
> autovacuum_analyze_scale_factor in 0.001
The autovacuum scale factor has been twice the autoanalyze scale factor since the
beginning. You could search the archives from around 2004 for a reason, but I'd
say it might have to do with the fact that ANALYZE is much cheaper than VACUUM,
and that the impact of bad statistics is usually more severe than the impact of
some dead tuples.
But there is no need for you to keep it that way when you change the parameters.
For example, if you want to speed up index only scans, you may want to set
"autovacuum_vacuum_scale_factor" to something like 0.01, but leave
"autovacuum_analyze_scale_factor" at the default value.
The values that you suggest seem much too low - that will result in autovacuum
running all the time.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
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-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, garcortez@gmail.com
Subject: Re: autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor
In-Reply-To: <38c4371df337331ce4c8d97c3ea1ecce30fc4988.camel@cybertec.at>
* 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