Re: Assert while autovacuum was executing - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Assert while autovacuum was executing
Date
Msg-id CAA4eK1KXQLC2h6+B3-zkUXPQy0LPyzgrOMQdSGrMeHULmp781Q@mail.gmail.com
Whole thread Raw
In response to RE: Assert while autovacuum was executing  ("Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>)
Responses Re: Assert while autovacuum was executing
List pgsql-hackers
On Wed, Jun 28, 2023 at 7:26 AM Zhijie Hou (Fujitsu)
<houzj.fnst@fujitsu.com> wrote:
>
> On Monday, June 26, 2023 12:18 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> >
> > Fair enough. If we could have been convinced of this then we can keep the
> > required change only for HEAD. But anyway let's remove the work related to
> > both commits (72e78d831a and 3ba59ccc89) for now and then we can come
> > back to it when we parallelize writes. The attached patch removes the changes
> > added by both commits with slight tweaking in comments/readme based on
> > the recent state.
>
> Thanks for the patch. I have confirmed that the patch to revert page lock
> handling applies cleanly on all branches(13~HEAD) and the assert failure and
> undetectable deadlock problem are fixed after applying the patch.
>

Thanks for the verification. Unless someone has any further comments
or suggestions, I'll push this next week sometime.

--
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: ReadRecentBuffer() doesn't scale well
Next
From: Richard Guo
Date:
Subject: Re: Assert !bms_overlap(joinrel->relids, required_outer)