Postgres Pro
Downloads
Home   >   mailing lists

Thread: Vacuum & analyze thresholds-- redundant?

Vacuum & analyze thresholds-- redundant?

From
Wells Oliver
Date:
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?

From
Tom Lane
Date:
Wells Oliver <wells.oliver@gmail.com> writes:
> Does a vacuum prompt an analyze?

No, they're determined independently.

            regards, tom lane