Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?
Date: 2022-04-03 18:53:03
Message-ID: 20220403185303.futnxfj64llw4uny@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

We've had bugs in pg_upgrade where post-upgrade xid horizons weren't correctly
set. We've had bugs were indexes were corrupted during replay.

The latter can be caught by wal_consistency_checking - but that's pretty
expensive.

It seems $subject would have a chance of catching some of these bugs, as well
as exposing amcheck to a database with a bit more varied content?

Depending on the cost it might make sense to do this optionally, via
PG_TEST_EXTRA?

Greetings,

Andres Freund

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2022-04-03 19:05:32 Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations
Previous Message David G. Johnston 2022-04-03 18:50:26 Re: unlogged sequences