public inbox for [email protected]  

help / color / mirror / Atom feed

From: Martín Marqués <[email protected]>
To: Alvaro Herrera <[email protected]>
Cc: [email protected]
Subject: Re: Incorrect description of autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor
Date: Thu, 27 Sep 2018 22:26:04 -0300
Message-ID: <CABeG9LvonWLrcYV=Y3yr_2+dZaMKNWOONGqZWLqX9A+N6u9xtA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

El jue., 27 sept. 2018 a las 18:05, Alvaro Herrera
(<[email protected]>) escribió:
>
> I suggest adding "This number is added to the number coming from the
> autovacuum_vacuum_scale_factor parameter for each table" just before the
> "This parameter can only be set" phrase.  So we'd end up with this:
>
> autovacuum_vacuum_threshold (integer)
> Specifies the minimum number of updated or deleted tuples needed to trigger a VACUUM in any one table. The default is 50 tuples. This number is added to the number coming from the autovacuum_vacuum_scale_factor parameter for each table.  This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters.
>
> autovacuum_vacuum_scale_factor (floating point)
> Specifies a fraction of the table size to add to autovacuum_vacuum_threshold when deciding whether to trigger a VACUUM. The default is 0.2 (20% of table size). This number is added to the autovacuum_vacuum_threshold parameter for each table.  This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters.

That looks very good IMO.

--
Martín Marqués
It’s not that I have something to hide,
it’s that I have nothing I want you to see

view thread (3+ messages)

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Incorrect description of autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor
  In-Reply-To: <CABeG9LvonWLrcYV=Y3yr_2+dZaMKNWOONGqZWLqX9A+N6u9xtA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox