Re: Optional skipping of unchanged relations during ANALYZE?

Поиск
Список
Период
Сортировка
От Ilia Evdokimov
Тема Re: Optional skipping of unchanged relations during ANALYZE?
Дата
Msg-id 81f859c4-aeb3-4405-b7de-7df9c3dcdac3@tantorlabs.com
обсуждение исходный текст
Ответ на Re: Optional skipping of unchanged relations during ANALYZE?  (VASUKI M <vasukianand0119@gmail.com>)
Список pgsql-hackers
Hi,

On 29.01.2026 15:19, VASUKI M wrote:
> I am back with a new patch.

1. It would be good to test this with assertions enabled. it would be 
good to test this with assertions enabled. I noticed: MISSING_STATS is 
currently defined withthe same bit value as FREEZE (0x08).

2. The current placement of the MISSING_STATS check insideanalyze_rel() 
looks problematic. Right now it is executed immediately after 
vacuum_open_relation(), beforewe verify that the relation was 
successfully opened and is not pg_statistic, the user has privileges. It 
seems more appropriate to move the MISSING_STATS check further 
down,after the standard skip conditions.

-- 
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/




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