| From: | Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> |
|---|---|
| To: | VASUKI M <vasukianand0119(at)gmail(dot)com>, Sami Imseih <samimseih(at)gmail(dot)com> |
| Cc: | Robert Treat <rob(at)xzilla(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Christoph Berg <myon(at)debian(dot)org> |
| Subject: | Re: Optional skipping of unchanged relations during ANALYZE? |
| Date: | 2026-01-29 15:25:12 |
| Message-ID: | 81f859c4-aeb3-4405-b7de-7df9c3dcdac3@tantorlabs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gilles Darold | 2026-01-29 15:39:54 | Re: Pasword expiration warning |
| Previous Message | Melanie Plageman | 2026-01-29 15:16:26 | Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) |