On Sun, Jul 4, 2021 at 2:26 PM Floris Van Nee <florisvan...@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 check in the tx log) dated from > February 2021. I do believe (but am not 100% certain) that the affected table > already existed at the time of the last pg_upgrade though.
I wonder if it's related to this issue: https://www.postgresql.org/message-id/20210423234256.hwopuftipdmp3...@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
