Re: Flaky vacuum truncate test in reloptions.sql - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: Flaky vacuum truncate test in reloptions.sql
Date
Msg-id CAD21AoB+qb-sOY2QeTnGirjh-UvFJj8eANVwQ4CV-r+t1AhxDA@mail.gmail.com
Whole thread Raw
In response to Re: Flaky vacuum truncate test in reloptions.sql  (Arseny Sher <a.sher@postgrespro.ru>)
Responses Re: Flaky vacuum truncate test in reloptions.sql
List pgsql-hackers
On Tue, Mar 30, 2021 at 10:22 PM Arseny Sher <a.sher@postgrespro.ru> wrote:
>
> On 3/30/21 10:12 AM, Michael Paquier wrote:
>
>  > Yep, this is the same problem as the one discussed for c2dc1a7, where
>  > a concurrent checkpoint may cause a page to be skipped, breaking the
>  > test.
>
> Indeed, Alexander Lakhin pointed me to that commit after I wrote the
> message.
>
>  > Why not just using DISABLE_PAGE_SKIPPING instead here?
>
> I think this is not enough. DISABLE_PAGE_SKIPPING disables vm consulting
> (sets
> aggressive=true in the routine); however, if the page is locked and
> lazy_check_needs_freeze says there is nothing to freeze on it, we again
> don't
> look at its contents closely.

Right.

Is it better to add FREEZE to the first "VACUUM reloptions_test;" as well?

Regards,

-- 
Masahiko Sawada
EDB:  https://www.enterprisedb.com/



pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: UniqueKey on Partitioned table.
Next
From: Amit Kapila
Date:
Subject: Re: [PATCH] add concurrent_abort callback for output plugin