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

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?
Дата
Msg-id 3031fc19-7540-b8be-e34b-835e6fc4493e@dunslane.net
обсуждение исходный текст
Ответ на Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
On 4/3/22 22:10, Peter Geoghegan wrote:
> On Sun, Apr 3, 2022 at 11:53 AM Andres Freund <andres@anarazel.de> wrote:
>> 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?
> I thought that Andrew Dunstan (CC'd) had a BF animal that did this
> setup. But I'm not sure if that ever ended up happening.


I don't think any of my BF animals do anything special in this area.


cheers


andrew


--
Andrew Dunstan
EDB: https://www.enterprisedb.com




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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: should vacuum's first heap pass be read-only?
Следующее
От: Amit Langote
Дата:
Сообщение: Re: generic plans and "initial" pruning