vacuum不做任何操作 vacuum full重建索引 Confidential │ ©2021 VMware, Inc. Brin Storage Revmap是一个逻辑上的数组，数组下标代表BlockNumber Revmap的value是TID，指向存储有最大最小值的tuple Confidential │ ©2021 VMware, Inc. 目录 Brin Index ©2021 VMware, Inc. Revmap With AO Confidential │ ©2021 VMware, Inc. Add an upper level Confidential │ ©2021 VMware, Inc. Brin on AO Storage Upper Level：定长数据段，约为3.2MB RevMap：变长数据段，大小随数据表数据 量变化，向后增长 relationship between the block number and the upper level array upper_index=blocknum/TidNumPerPage revmap_offset=blocknum%TidNumPerPage Confidential │ ©2021 VMware, Inc. 目录 Brin Index AppendOnly

• Fix incorrect WAL logging for BRIN indexes (Kuntal Ghosh) The WAL record emitted for a BRIN “revmap” page when moving an index tuple to a different page was incorrect. Replay would make the related 4 | 2 brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For example: test=# SELECT * FROM brin_revmap_data(get_raw_page(’brinidx’ type), 145 BRIN (see index) brin_metapage_info, 2369 brin_page_items, 2370 brin_page_type, 2369 brin_revmap_data, 2369 brin_summarize_new_values, 330 broadcast, 252 btree_gin, 2293 btree_gist, 2294 btrim,

• Fix incorrect WAL logging for BRIN indexes (Kuntal Ghosh) The WAL record emitted for a BRIN “revmap” page when moving an index tuple to a different page was incorrect. Replay would make the related 4 | 2 brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For exam- ple: test=# SELECT * FROM brin_revmap_data(get_raw_page(’brinidx’ type), 154 BRIN (see index) brin_metapage_info, 2514 brin_page_items, 2514 brin_page_type, 2514 brin_revmap_data, 2514 brin_summarize_new_values, 350 broadcast, 267 btree_gin, 2433 btree_gist, 2433 btrim,

• Fix incorrect WAL logging for BRIN indexes (Kuntal Ghosh) The WAL record emitted for a BRIN “revmap” page when moving an index tuple to a different page was incorrect. Replay would make the related 4 | 2 brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For exam- ple: test=# SELECT * FROM brin_revmap_data(get_raw_page(’brinidx’ type), 155 BRIN (see index) brin_metapage_info, 2608 brin_page_items, 2609 brin_page_type, 2608 brin_revmap_data, 2608 brin_summarize_new_values, 364 broadcast, 273 BSD Authentication, 627 btree_gin, 2525

• Fix incorrect WAL logging for BRIN indexes (Kuntal Ghosh) The WAL record emitted for a BRIN “revmap” page when moving an index tuple to a different page was incorrect. Replay would make the related 4 | 2 brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For example: test=# SELECT * FROM brin_revmap_data(get_raw_page(’brinidx’ type), 145 BRIN (see index) brin_metapage_info, 2466 brin_page_items, 2466 brin_page_type, 2465 brin_revmap_data, 2466 brin_summarize_new_values, 342 broadcast, 256 BSD Authentication, 594 btree_gin, 2387

2 brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For example: test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx' brin_desummarize_range, 356 brin_metapage_info, 2550 brin_page_items, 2550 brin_page_type, 2550 brin_revmap_data, 2550 brin_summarize_new_values, 356 brin_summarize_range, 356 broadcast, 266 BSD Authentication

2 brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For example: test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx' brin_desummarize_range, 337 brin_metapage_info, 2425 brin_page_items, 2425 brin_page_type, 2425 brin_revmap_data, 2425 brin_summarize_new_values, 337 brin_summarize_range, 337 broadcast, 252 BSD Authentication

2 brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For example: test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx' brin_desummarize_range, 357 brin_metapage_info, 2563 brin_page_items, 2564 brin_page_type, 2563 brin_revmap_data, 2564 brin_summarize_new_values, 357 brin_summarize_range, 357 broadcast, 269 BSD Authentication

2 brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For example: test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx' brin_desummarize_range, 416 brin_metapage_info, 2828 brin_page_items, 2828 brin_page_type, 2828 brin_revmap_data, 2828 brin_summarize_new_values, 415 brin_summarize_range, 416 broadcast, 309 BSD Authentication

Modules brin_revmap_data(page bytea) returns setof tid brin_revmap_data returns the list of tuple identifiers in a BRIN index range map page. For example: test=# SELECT * FROM brin_revmap_data(get_raw_page('brinidx' brin_desummarize_range, 393 brin_metapage_info, 2679 brin_page_items, 2680 brin_page_type, 2679 brin_revmap_data, 2680 brin_summarize_new_values, 393 brin_summarize_range, 393 broadcast, 292 BSD Authentication