Do not check unlogged indexes on standby

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Geoghegan <pg(at)bowt(dot)ie>
Subject: Do not check unlogged indexes on standby
Date: 2019-08-12 09:58:24
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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..


Best regards, Andrey Borodin.

Attachment Content-Type Size
0001-Do-not-verify-unlogged-indexes-during-amcheck.patch application/octet-stream 2.5 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2019-08-12 11:19:41 Re: errbacktrace
Previous Message Antonin Houska 2019-08-12 08:56:36 Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)