Re: Optional skipping of unchanged relations during ANALYZE? - Mailing list pgsql-hackers

From Ilia Evdokimov
Subject Re: Optional skipping of unchanged relations during ANALYZE?
Date
Msg-id 81f859c4-aeb3-4405-b7de-7df9c3dcdac3@tantorlabs.com
Whole thread Raw
In response to Re: Optional skipping of unchanged relations during ANALYZE?  (VASUKI M <vasukianand0119@gmail.com>)
List 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 by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)
Next
From: Gilles Darold
Date:
Subject: Re: Pasword expiration warning