Re: Remaining case where reltuples can become distorted across multiple VACUUM operations

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Remaining case where reltuples can become distorted across multiple VACUUM operations
Date: 2022-08-08 14:51:51
Message-ID: CAH2-Wzn3an_othuJpveULWDgU-ax8BTgQRg=hzeZECGc0heUeA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 5, 2022 at 5:39 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached patch fixes closes the remaining gap. With the patch applied,
> the second and subsequent vacuum verbose operations from the test case
> will show that reltuples is still 10000 (it won't ever change). The
> patch just extends an old behavior that was applied when scanned_pages
> == 0 to cases where scanned_pages <= 1 (unless we happened to scan all
> of the relation's tables, of course).

My plan is to commit this later in the week, barring objections. Maybe
on Thursday.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2022-08-08 14:56:21 Re: `make check` doesn't pass on MacOS Catalina
Previous Message Tom Lane 2022-08-08 14:32:22 Re: bug on log generation ?