Horton

Re: doc: fix pg_stat_autovacuum_scores threshold wording

Sami Imseih <samimseih@gmail.com>

View thread View on postgr.es
From: Sami Imseih <samimseih@gmail.com>
To: Chao Li <li.evan.chao@gmail.com>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, pgsql-hackers@lists.postgresql.org, nathandbossart@gmail.com
Date: 2026-06-25T15:48:07Z
Lists: pgsql-hackers 
> I guess that may be how the current wording came from. But it seems a bit indirect to describe it that way, because the weight itself does not determine if autovacuum would vacuum or analyze the table.
>
> Rewriting the doc more broadly would be a larger change. This small patch is only meant to avoid the confusion shown by the test earlier, where the score is equal to the weight but do_vacuum is false.

Hi,

Thanks for reporting. I took a look and agree with your doc changes.
do_vacuum/do_analyze will not be true for cases where the
individual component scores are less than or equal to the weight.

The patch LGTM

--
Sami Imseih
Amazon Web Services (AWS)

Commits

  1. doc: Fix pg_stat_autovacuum_scores descriptions.