Postgres Pro
Downloads
Home   >   mailing lists

Vacuum & analyze thresholds-- redundant? - Mailing list pgsql-admin

From Wells Oliver
Subject Vacuum & analyze thresholds-- redundant?
Date
Msg-id CAOC+FBUuqhHCHUUYxk2PH24Q2u2B4ORPG91u5QQgpN0oHk8G4g@mail.gmail.com
Whole thread Raw
Responses Re: Vacuum & analyze thresholds-- redundant?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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.

--

pgsql-admin by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Large number of partitions of a table
Next
From: Ron
Date:
Subject: Re: Large number of partitions of a table