Horton

Do not check unlogged indexes on standby

x4mmm@yandex-team.ru

View thread View on postgr.es
From: Andrey Borodin <x4mmm@yandex-team.ru>
To: pgsql-hackers <pgsql-hackers@postgresql.org>, Peter Geoghegan <pg@bowt.ie>
Date: 2019-08-12T09:58:24Z
Lists: pgsql-hackers

Attachments

Hi hackers!

Currently, if we check indexes on standby we often get

man-psbpshn0skhsxynd/xiva_xtable_testing_01 R # select bt_index_check('xiva_loadtest.pk_uid');
ERROR:  58P01: could not open file "base/16453/125407": No such file or directory

I think that we should print warning and that's it. Amcheck should not give false positives.

Or, maybe, there are some design considerations that I miss?


BTW I really want to enable rightlink-leftlink invariant validation on standby..

Thanks!

Best regards, Andrey Borodin.

Commits

  1. amcheck: Skip unlogged relations during recovery.