Optional skipping of unchanged relations during ANALYZE?

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v6, Patch count: 1, First patch: +342−6, All patches: +342−6

Tags

Performance psql SQL Commands

Created

2026-02-23 07:08:29

Last modified

2026-02-23 07:08:29 (2 weeks ago)

Latest email

2026-03-04 11:21:38 (1 week ago)

Status

PG19-Final (2026-03-01 – 2026-03-31): Needs review

Target version

Authors

Vasu M (vasu01)

Reviewers

Ilia Evdokimov (ilidock95)Become reviewer

Committer

Links

Emails

Optional skipping of unchanged relations during ANALYZE?: First at 2026-01-20 10:24:48 by VASUKI M <vasukianand0119 at gmail.com>
Latest at 2026-03-04 11:21:38 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest attachment (v6-0001-ANALYZE-add-MISSING_STATS_ONLY-option.patch) at 2026-03-02 12:48:05 from VASUKI M <vasukianand0119 at gmail.com>
    Attachment (v6-0001-ANALYZE-add-MISSING_STATS_ONLY-option.patch) at 2026-03-02 12:48:05 from VASUKI M <vasukianand0119 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-ANALYZE-add-MISSING_STATS_ONLY-option.patch) at 2026-02-16 12:19:53 from VASUKI M <vasukianand0119 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-ANALYZE-add-MISSING_STATS_ONLY-option.patch) at 2026-02-13 12:14:30 from VASUKI M <vasukianand0119 at gmail.com> (Patch: Yes)
    Attachment (vacuumdb_missing_stats_only.sql) at 2026-01-29 18:54:30 from Sami Imseih <samimseih at gmail.com> (Patch: No)
    Attachment (v3-0001-ANALYZE-add-MISSING_STATS-option.patch) at 2026-01-29 12:19:47 from VASUKI M <vasukianand0119 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-ANALYZE-Introduce-an-opt-in-SMART-option.patch) at 2026-01-22 09:19:00 from VASUKI M <vasukianand0119 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-ANALYZE-add-optional-smart-mode-to-skip-unchanged-relations.patch) at 2026-01-21 09:37:01 from VASUKI M <vasukianand0119 at gmail.com> (Patch: Yes)

History

When	Who	What
2026-03-03 13:58:29	Ilia Evdokimov (ilidock95)	Added ilidock95 as reviewer
2026-02-23 07:08:29	Vasu M (vasu01)	Attached mail thread CAE2r8H7+eACA+QxisuPY1jveA=YLuH7CE8F3TedmZfsKdYxOeA@mail.gmail.com
2026-02-23 07:08:29	Vasu M (vasu01)	Created patch record