Re: Nonrandom scanned_pages distorts pg_class.reltuples set by VACUUM

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Nonrandom scanned_pages distorts pg_class.reltuples set by VACUUM
Date: 2022-02-17 01:16:13
Message-ID: CAH2-WzkNDbL9dKTwq+CAzkMk-XO=duYSZ-iLLjE=FpMujpahzQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Feb 13, 2022 at 1:43 PM Peter Geoghegan <pg(at)bowt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-02-17 01:22:23 Re: Race conditions in 019_replslot_limit.pl
Previous Message Andres Freund 2022-02-17 01:11:09 Re: libpq async duplicate error results