Re: amcheck: add index-all-keys-match verification for B-Tree - Mailing list pgsql-hackers

From Zsolt Parragi
Subject Re: amcheck: add index-all-keys-match verification for B-Tree
Date
Msg-id CAN4CZFNdvMqgHpB04SSqDjv1Z5g3Dv2Z6Uyb4P5dDo6p04Z=Kg@mail.gmail.com
Whole thread
In response to Re: amcheck: add index-all-keys-match verification for B-Tree  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: amcheck: add index-all-keys-match verification for B-Tree
List pgsql-hackers
I don't see any other logic problems in the code, I only have a few
minor comments/questions:

+ * Bloom filter says (key, tid) not in heap.  Follow TID to verify; this
+ * amortizes random heap lookups when the filter has false negatives, or

This comment could be a bit confusing, as bloom filters typically have
false positives, not negatives.
Maybe it would be better to phrase this somehow differently?

Another thing is that now amcheck can create two bloom filters,
allocated at the same time, both up to maintenance_work_mem.
Isn't that a detail that should be at least mentioned somewhere?

And in the documentation, shouldn't this new check mention something
similar to heapallindexed, which describes the check possibly missing
corruption because of the bloom filter?

+ (errcode(ERRCODE_INDEX_CORRUPTED),
+ errmsg("index tuple in index \"%s\" does not match heap tuple",
+ RelationGetRelationName(state->rel)),

Shouldn't this also print out the table name?



pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: Question: rebuilding frontend tools after libpgfeutils.a changes?
Next
From: Melanie Plageman
Date:
Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)