On Sun, Jul 4, 2021 at 2:26 PM Floris Van Nee <florisvannee@optiver.com> wrote:
> > Have you ever used pg_upgrade on this database?
> >
>
> Yes. The last time (from v11 to v12) was in October 2020. The transaction id in the tuples (the one PG is trying to
checkin the tx log) dated from February 2021. I do believe (but am not 100% certain) that the affected table already
existedat the time of the last pg_upgrade though.
I wonder if it's related to this issue:
https://www.postgresql.org/message-id/20210423234256.hwopuftipdmp3okf@alap3.anarazel.de
Have you increased autovacuum_freeze_max_age from its default? This
already sounds like the kind of database where that would make sense.
--
Peter Geoghegan