Re: recovering from "found xmin ... from before relfrozenxid ..." - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: recovering from "found xmin ... from before relfrozenxid ..."
Date
Msg-id D2B1B103-20D7-4BD0-BAC7-470A319DC3E1@yandex-team.ru
Whole thread Raw
In response to Re: recovering from "found xmin ... from before relfrozenxid ..."  (Ashutosh Sharma <ashu.coek88@gmail.com>)
List pgsql-hackers

> 31 июля 2020 г., в 17:32, Ashutosh Sharma <ashu.coek88@gmail.com> написал(а):
>
>
> On Wed, Jul 29, 2020 at 9:58 AM Ashutosh Sharma <ashu.coek88@gmail.com> wrote:
>
> > I think we should let VACUUM do that.
> Sometimes VACUUM will not get to these pages, because they are marked All Frozen.
> An possibly some tuples will get stale on this page again
>
> Hmm, okay, will have a look into this. Thanks.
>
> I had a look over this and found that one can use the DISABLE_PAGE_SKIPPING option with VACUUM to disable all its
page-skippingbehavior. 

Oh, wow, I didn't know that. Thanks! This actually will do the trick.
I'll try to review your patch again next week.

Thanks!

Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Why is pq_begintypsend so slow?
Next
From: Robert Haas
Date:
Subject: Re: Why is pq_begintypsend so slow?