diff options
| author | Teodor Sigaev <teodor@sigaev.ru> | 2018-04-25 18:02:55 +0300 |
|---|---|---|
| committer | Teodor Sigaev <teodor@sigaev.ru> | 2018-04-25 18:02:55 +0300 |
| commit | 4eaf7eaccb291f5d32d9f05284bfca9c5744de9a (patch) | |
| tree | c4f4ef2c28d23aad6e4b50463a5ac037cbdbf6cc /contrib/jsonb_plpython/sql/jsonb_plpython.sql | |
| parent | 7f58f666cdeee8016fd4ec7aa79629c983ecc3bd (diff) | |
| download | postgresql-4eaf7eaccb291f5d32d9f05284bfca9c5744de9a.tar.gz postgresql-4eaf7eaccb291f5d32d9f05284bfca9c5744de9a.zip | |
Add missing and dangling downlink checks to amcheck
When bt_index_parent_check() is called with the heapallindexed option,
allocate a second Bloom filter to fingerprint block numbers that appear
in the downlinks of internal pages. Use Bloom filter probes when
walking the B-Tree to detect missing downlinks. This can detect subtle
problems with page deletion/VACUUM, such as corruption caused by the bug
just fixed in commit 6db4b499.
The downlink Bloom filter is bound in size by work_mem. Its optimal
size is typically far smaller than that of the regular heapallindexed
Bloom filter, especially when the index has high fan-out.
Author: Peter Geoghegan
Reviewer: Teodor Sigaev
Discussion: https://postgr.es/m/CAH2-WznUzY4fWTjm1tBB3JpVz8cCfz7k_qVp5BhuPyhivmWJFg@mail.gmail.com
Diffstat (limited to 'contrib/jsonb_plpython/sql/jsonb_plpython.sql')
0 files changed, 0 insertions, 0 deletions