On Thursday 2025-10-30 18:00, Ron Johnson wrote:
On Thu, Oct 30, 2025 at 11:55 AM Dimitrios Apostolou <[email protected]> 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
