| 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 |
| Message-ID: | DA9B33AC-53CB-4643-96D4-7A0BBC037FA1@yandex-team.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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..
Thanks!
Best regards, Andrey Borodin.
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Do-not-verify-unlogged-indexes-during-amcheck.patch | application/octet-stream | 2.5 KB |
| 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) |