Re: Track skipped tables during autovacuum and autoanalyze
Sami Imseih <samimseih@gmail.com>
From: Sami Imseih <samimseih@gmail.com>
To: Yugo Nagata <nagata@sraoss.co.jp>
Cc: Michael Paquier <michael@paquier.xyz>,
Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2026-04-22T12:49:55Z
Lists: pgsql-hackers
Thanks for the updated patch! > I've attached a patch reflecting your comments on items 1, 2, and 5. > As for items 3, 4, and 6, I am waiting for your comments, so the patch > is left unchanged for now. A few more comments: 1/ + relid = RangeVarGetRelid(vrel->relation, NoLock, false); Should this be called with "true" as the 3rd (missing_ok) argument, otherwise we end up with an error instead of a "--- relation no longer exists" log. right? 2/ Can the isolation tests src/test/isolation/specs/vacuum-skip-locked.spec be updated to check pg_stat_user_tables as well? 3/ comment fix: This: * Relation could not be opened hence generate if possible a log Should be: * Relation could not be opened, hence generate if possible a log -- Sami Imseih Amazon Web Services (AWS)