MIME-Version: 1.0
References: <153807973105.1233.5572348777789365646@wrigleys.postgresql.org>
 <20180927210540.od23ee3aq4bpkbpj@alvherre.pgsql>
In-Reply-To: <20180927210540.od23ee3aq4bpkbpj@alvherre.pgsql>
From: =?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= <martin.marques@gmail.com>
Date: Thu, 27 Sep 2018 22:26:04 -0300
Message-ID: 
 <CABeG9LvonWLrcYV=Y3yr_2+dZaMKNWOONGqZWLqX9A+N6u9xtA@mail.gmail.com>
Subject: Re: Incorrect description of autovacuum_vacuum_threshold and
 autovacuum_vacuum_scale_factor
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

El jue., 27 sept. 2018 a las 18:05, Alvaro Herrera
(<alvherre@2ndquadrant.com>) escribi=C3=B3:
>
> 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 trigg=
er a VACUUM in any one table. The default is 50 tuples. This number is adde=
d to the number coming from the autovacuum_vacuum_scale_factor parameter fo=
r each table.  This parameter can only be set in the postgresql.conf file o=
r on the server command line; but the setting can be overridden for individ=
ual tables by changing table storage parameters.
>
> autovacuum_vacuum_scale_factor (floating point)
> Specifies a fraction of the table size to add to autovacuum_vacuum_thresh=
old when deciding whether to trigger a VACUUM. The default is 0.2 (20% of t=
able size). This number is added to the autovacuum_vacuum_threshold paramet=
er for each table.  This parameter can only be set in the postgresql.conf f=
ile or on the server command line; but the setting can be overridden for in=
dividual tables by changing table storage parameters.

That looks very good IMO.

--
Mart=C3=ADn Marqu=C3=A9s
It=E2=80=99s not that I have something to hide,
it=E2=80=99s that I have nothing I want you to see