Re: Why does pg_class.reltuples count only live tuples in indexes (after VACUUM runs)?

On Mon, Apr 18, 2022 at 1:10 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The places where index AMs refer to num_heap_tuples seem to be using
> it as a ceiling on estimated index tuple counts.  Given that we should
> be counting dead index entries, redefining it as you suggest would be
> wrong.

I would argue that it would be correct for the first time -- at least
if we take the behavior within heapam_index_build_range_scan (and
everywhere else) as authoritative. That's a feature, not a bug.

-- 
Peter Geoghegan