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 EFCB93C4-E42F-4E54-9408-9469FC493DC2@yandex-team.ru
Whole thread Raw
In response to recovering from "found xmin ... from before relfrozenxid ..."  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hi!

> 14 июля 2020 г., в 02:12, Robert Haas <robertmhaas@gmail.com> написал(а):
>
> So I have these questions:
>
> - Do people think it would me smart/good/useful to include something
> like this in PostgreSQL?
>
> - If so, how? I would propose a new contrib module that we back-patch
> all the way


My 0.05₽.

At Yandex we used to fix similar corruption things with our pg_dirty_hands extension [0].
But then we developed our internal pg_heapcheck module (unfortunately we did not publish it) and incorporated
aggressiverecovery into heapcheck. 

Now when community has official heapcheck I think it worth to keep detection and fixing tools together.

Best regards, Andrey Borodin.

[0] https://github.com/dsarafan/pg_dirty_hands/blob/master/src/pg_dirty_hands.c




pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: possibility to read dumped table's name from file