Обсуждение: Vacuum & analyze thresholds-- redundant?

Поиск
Список
Период
Сортировка

Vacuum & analyze thresholds-- redundant?

От
Wells Oliver
Дата:
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.

--

Re: Vacuum & analyze thresholds-- redundant?

От
Tom Lane
Дата:
Wells Oliver <wells.oliver@gmail.com> writes:
> Does a vacuum prompt an analyze?

No, they're determined independently.

            regards, tom lane