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

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?
Дата
Msg-id 20220403185303.futnxfj64llw4uny@alap3.anarazel.de
обсуждение исходный текст
Ответы Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: unlogged sequences
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations