Re: Track skipped tables during autovacuum and autoanalyze - Mailing list pgsql-hackers

From Sami Imseih
Subject Re: Track skipped tables during autovacuum and autoanalyze
Date
Msg-id CAN12+YLDPuW8iF=UqXyLzmjM9MkHbx2YwwKq+8G2-HcO8Kzyfg@mail.gmail.com
Whole thread
In response to Re: Track skipped tables during autovacuum and autoanalyze  (Shinya Kato <shinya11.kato@gmail.com>)
Responses Re: Track skipped tables during autovacuum and autoanalyze
List pgsql-hackers
> On Tue, Sep 15, 2026 at 4:43 AM Sami Imseih <samimseih.pg@gmail.com> wrote:
> > This is less about stats reporting and more about filtering out such
> > relations earlier in expand_vacuum_rel() for manually specified
> > VACUUM/ANALYZE targets. Not a big thing, but it would avoid an extra
> > syscache lookup and a misleading "lock not available" warning.
>
> I would like to fold one more case into that follow-up. The skip is
> reported before vacuum_is_permitted_for_relation(), so a user with no
> rights on the table can still move its counters.
>
> The callback argument of RangeVarGetRelidExtended() looks like the
> right place for all of this. It runs before the lock attempt, and the
> comment there already says that is where permission checks belong. It
> also hands us relId, so expand_vacuum_rel() would no longer need the
> second RangeVarGetRelid(..., NoLock, true) lookup.

It may be worth cleaning this stuff up if someone is interested in taking
this on.

v16 is just a rebase. I also took out the catversion change for now, but made
it clear it's required in the commit message.

--
Sami Imseih
Amazon Web Services (AWS)

Attachment

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)
Next
From: Atsushi Ogawa
Date:
Subject: Re: [PATCH] Use Boyer-Moore-Horspool for simple LIKE contains patterns