Re: Do not check unlogged indexes on standby - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Do not check unlogged indexes on standby
Date
Msg-id CAH2-WzkjPUdZyYs+Z2kH5Go05ZFFk68q7jmUQ6asXX_JvixcCQ@mail.gmail.com
Whole thread Raw
In response to Do not check unlogged indexes on standby  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: Do not check unlogged indexes on standby  (Andrey Borodin <x4mmm@yandex-team.ru>)
List pgsql-hackers
On Mon, Aug 12, 2019 at 2:58 AM Andrey Borodin <x4mmm@yandex-team.ru> wrote:
> BTW I really want to enable rightlink-leftlink invariant validation on standby..

That seems very hard. My hope was that bt_check_index() can detect the
same problem a different way. The bt_right_page_check_scankey()
cross-page check (which needs nothing more than an AccessShareLock)
will often detect such problems, because the page image itself will be
totally wrong in some way.

I'm guessing that you have direct experience with that *not* being
good enough, though. Can you share further details? I suppose that
bt_right_page_check_scankey() helps with transposed pages, but doesn't
help so much when you have WAL-level inconsistencies.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [Proposal] Table-level Transparent Data Encryption (TDE) and KeyManagement Service (KMS)
Next
From: Thomas Munro
Date:
Subject: Re: pg_stat_replication lag fields return non-NULL values even withNULL LSNs