Vacuum & analyze thresholds-- redundant?

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Vacuum & analyze thresholds-- redundant?
Date: 2022-01-19 01:42:16
Message-ID: CAOC+FBUuqhHCHUUYxk2PH24Q2u2B4ORPG91u5QQgpN0oHk8G4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Does a vacuum prompt an analyze? I have the following settings on a table:

alter table t set (autovacuum_analyze_scale_factor = 0);
alter table t set (autovacuum_analyze_threshold = 10000);

alter table t set (autovacuum_vacuum_scale_factor = 0);
alter table t set (autovacuum_vacuum_threshold = 10000);

Wondering if there is redundancy there.

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2022-01-19 01:48:58 Re: Large number of partitions of a table
Previous Message Mladen Gogala 2022-01-19 00:09:55 Re: Large number of partitions of a table