Re: pg15: reltuples stuck at -1 after pg_upgrade and VACUUM

On Tue, Aug 8, 2023 at 8:43 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
> The problem isn't that reltuples == -1 after the upgrade (which is
> normal).  The issue is that if VACUUM skips all the pages, it can leave
> reltuples -1.  My expectation is that after running "vacuum", no tables
> are left in the "never have been vacuumed" state.

But -1 isn't the "never have been vacuumed" state, exactly. At best it
is the "never been vacuumed or analyzed" state.

--
Peter Geoghegan