Re: Nonrandom scanned_pages distorts pg_class.reltuples set by VACUUM - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Nonrandom scanned_pages distorts pg_class.reltuples set by VACUUM
Date
Msg-id CAH2-WzkNDbL9dKTwq+CAzkMk-XO=duYSZ-iLLjE=FpMujpahzQ@mail.gmail.com
Whole thread Raw
In response to Nonrandom scanned_pages distorts pg_class.reltuples set by VACUUM  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Nonrandom scanned_pages distorts pg_class.reltuples set by VACUUM  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On Sun, Feb 13, 2022 at 1:43 PM Peter Geoghegan <pg@bowt.ie> wrote:
> This fixes the observed problem directly. It also makes the code
> robust against other similar problems that might arise in the future.
> The risk that comes from trusting that scanned_pages is a truly random
> sample (given these conditions) is generally very large, while the
> risk that comes from disbelieving it (given these same conditions) is
> vanishingly small.

Pushed.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: libpq async duplicate error results
Next
From: Tom Lane
Date:
Subject: Re: Race conditions in 019_replslot_limit.pl