Re: Optional skipping of unchanged relations during ANALYZE?

Поиск
Список
Период
Сортировка
Искать
От
Andreas Karlsson
Тема
Re: Optional skipping of unchanged relations during ANALYZE?
Дата
в 19:27:15
Msg-id
be509f90-74bd-4a81-83a7-d5afa0d17b38@proxel.se
Ответ на
Список
Дерево обсуждения
Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Christoph Berg <myon@debian.org>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? David Rowley <dgrowleyml@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Robert Treat <rob@xzilla.net>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Christoph Berg <myon@debian.org>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Christoph Berg <myon@debian.org>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Robert Treat <rob@xzilla.net>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Corey Huinker <corey.huinker@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Corey Huinker <corey.huinker@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Corey Huinker <corey.huinker@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Corey Huinker <corey.huinker@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Andreas Karlsson <andreas@proxel.se>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Robert Treat <rob@xzilla.net>
Re: Optional skipping of unchanged relations during ANALYZE? Sami Imseih <samimseih@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
Re: Optional skipping of unchanged relations during ANALYZE? Corey Huinker <corey.huinker@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? VASUKI M <vasukianand0119@gmail.com>
Re: Optional skipping of unchanged relations during ANALYZE? Robert Treat <rob@xzilla.net>
Re: Optional skipping of unchanged relations during ANALYZE? Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
On 2/13/26 1:14 PM, VASUKI M wrote:
> As discussed earlier in the thread, I plan to start a new discussion and 
> patch series for a separate ANALYZE (MODIFIED_STATS) option that would 
> reuse autoanalyze-style thresholds. I believe keeping MISSING_STATS_ONLY 
> and MODIFIED_STATS as separate, clearly defined options makes the 
> semantics easier to reason about.

When would a user ever want MODIFIED_STATS without also analyzing tables 
without any stats? I had more thought of calling it something like 
SKIP_UNMODIFIED but maybe there is a case for MISSING_STATS_ONLY, 
especially since the command line tool supports it.

Andreas



В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: AIX support
От: Lukas Fittl
Дата:
FAQ