From: | Martín Marqués <martin(dot)marques(at)gmail(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Incorrect description of autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor |
Date: | 2018-09-28 01:26:04 |
Message-ID: | CABeG9LvonWLrcYV=Y3yr_2+dZaMKNWOONGqZWLqX9A+N6u9xtA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
El jue., 27 sept. 2018 a las 18:05, Alvaro Herrera
(<alvherre(at)2ndquadrant(dot)com>) 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
From | Date | Subject | |
---|---|---|---|
Next Message | PG Doc comments form | 2018-10-01 09:42:08 | pgrowlocks columns do not match docs: "modes" instead of "lock_type" |
Previous Message | Alvaro Herrera | 2018-09-27 21:05:40 | Re: Incorrect description of autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor |