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

On Thu, Oct 30, 2025 at 2:41 PM Dimitrios Apostolou <jimis(at)gmx(dot)net> wrote:

> On Thursday 2025-10-30 18:00, Ron Johnson wrote:
>
> >On Thu, Oct 30, 2025 at 11:55 AM Dimitrios Apostolou <jimis(at)gmx(dot)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
>

https://www.postgresql.org/docs/17/runtime-config-autovacuum.html#GUC-AUTOVACUUM-ANALYZE-SCALE-FACTOR
"Specifies a fraction of the table size to add to
autovacuum_analyze_threshold when deciding whether to trigger an ANALYZE.
The default is 0.1 (10% of table size)."

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!