Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic

From: Andres Freund <andres(at)anarazel(dot)de>
To: Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Peter Geoghegan <pg(at)bowt(dot)ie>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic
Date: 2021-07-25 03:34:55
Message-ID: 20210725033455.acqjrf2noundyf3f@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2021-06-21 05:29:19 -0700, Andres Freund wrote:
> On 2021-06-16 12:12:23 -0700, Andres Freund wrote:
> > Could you share your testcase? I've been working on a series of patches
> > to address this (I'll share in a bit), and I've run quite a few tests,
> > and didn't hit any infinite loops.
>
> Sorry for not yet doing that. Unfortunately I have an ongoing family
> health issue (& associated travel) claiming time and energy :(.
>
> I've pushed the minimal fix due to beta 2.
>
> Beyond beta 2 I am thinking of the below to unify the horizon
> determination:
>
> static inline GlobalVisHorizonKind
> GlobalVisHorizonKindForRel(Relation rel)

I finally pushed this cleanup.

Greetings,

Andres Freund

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2021-07-25 08:16:06 Re: Maintain the pathkesy for subquery from outer side information
Previous Message Andres Freund 2021-07-25 03:34:22 pgsql: Deduplicate choice of horizon for a relation procarray.c.