Re: Remaining case where reltuples can become distorted across multiple VACUUM operations - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Remaining case where reltuples can become distorted across multiple VACUUM operations
Date
Msg-id CAH2-Wzn3an_othuJpveULWDgU-ax8BTgQRg=hzeZECGc0heUeA@mail.gmail.com
Whole thread Raw
In response to Remaining case where reltuples can become distorted across multiple VACUUM operations  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Remaining case where reltuples can become distorted across multiple VACUUM operations
List pgsql-hackers
On Fri, Aug 5, 2022 at 5:39 PM Peter Geoghegan <pg@bowt.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: bug on log generation ?
Next
From: Andrew Dunstan
Date:
Subject: Re: `make check` doesn't pass on MacOS Catalina