Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic
Date
Msg-id CAH2-WznW_tfJvVG_Unin68QJWF+aHdLE=6iUzfLZOAwdjJNdCw@mail.gmail.com
Whole thread Raw
In response to Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, Jun 8, 2021 at 5:11 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I wonder if this is a variant of the problem shown at
>
> https://www.postgresql.org/message-id/2591376.1621196582%40sss.pgh.pa.us
>
> where maybe_needed was visibly quite insane.  This value is
> less visibly insane, but it's still wrong.  It might be
> interesting to try running this test case with the extra
> assertions I proposed there, to try to narrow down where
> it's going off the rails.

Oh yeah. Justin didn't say anything about upgrading using pg_upgrade
(just something about upgrading the kernel).

Did you use pg_upgrade here, Justin?

I'm going to see Andres in person in 20 minutes time (for the first
time in over a year!). I'll discuss this issue with him.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: alter table set TABLE ACCESS METHOD
Next
From: Peter Geoghegan
Date:
Subject: Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic