Re: Optional skipping of unchanged relations during ANALYZE?

Поиск
Список
Период
Сортировка
От Sami Imseih
Тема Re: Optional skipping of unchanged relations during ANALYZE?
Дата
Msg-id CAA5RZ0s0y+tEQHiV4VWp+yopdX9hwyuS8GopHsP9YmK0peLFOA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optional skipping of unchanged relations during ANALYZE?  (VASUKI M <vasukianand0119@gmail.com>)
Ответы Re: Optional skipping of unchanged relations during ANALYZE?
Список pgsql-hackers
> The idea of introducing explicit options such as ANALYZE (MISSING_STATS)
> and ANALYZE (MODIFIED_STATS) feels like a much cleaner direction.
> In particular, starting with MISSING_STATS as a SQL-level equivalent of
> vacuumdb --missing-stats-only seems like a well-scoped and low-risk
> first step.

> I’m happy to pivot in this direction and focus first on a clear,
> well-defined MISSING_STATS option for ANALYZE, and then revisit
> MODIFIED_STATS (possibly reusing autoanalyze-style thresholds) as a
> follow-up, once there is agreement on the semantics.

I agree with this.

Thanks!

Sami Imseih
Amazon Web Services (AWS)



В списке pgsql-hackers по дате отправления: