Horton

Re: Why isn't my table auto-analyzed/vacuumed?

Dimitrios Apostolou <jimis@gmx.net>

View thread View on postgr.es
From: Dimitrios Apostolou <jimis@gmx.net>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Date: 2025-10-30T18:41:39Z
Lists: pgsql-general 
On Thursday 2025-10-30 18:00, Ron Johnson wrote:

>On Thu, Oct 30, 2025 at 11:55 AM Dimitrios Apostolou <jimis@gmx.net> wrote:

>      > SELECT name,setting FROM pg_settings WHERE name ILIKE '%factor%' ;
>                        name                  | setting
>      ---------------------------------------+---------
>        autovacuum_analyze_scale_factor       | 0.1
>
>
>0.1 means 10%.

Thank you Ron! I was quite sure 0.1 meant 1/1000 because of this:

SELECT min_val,max_val FROM pg_settings WHERE name = 'autovacuum_analyze_scale_factor' \gx

-[ RECORD 1 ]
min_val | 0
max_val | 100


I will adjust the values accordingly and check back. Cheers!

Dimitris