PostgreSQL Bitmap Index

What is a bitmap index?

Some features of bitmap indexing?

What are the advantages and disadvantages of bitmap indexing?

To see the example of the next image scan.

QUERY Plan----------------------------------------------------------------------------------------------------- ---------------------------------------Bitmap Heap Scan on bitmap_test (cost=2023.16..4157.75 rows=99967 width=4) ( Actual time=24.373..41.054 rows=100000 loop S=1) Recheck Cond: (is_visible = ' yes ':: Bpchar)-> Bitmap Index Scan on IDX _bitmap_is_visible (cost=0.00..1998.17 rows=99967 width=0) (actual time=24.252..24.252 ro ws=100000 loops=1) Index Cond: (is_visible = ' yes ':: Bpchar) Total runtime:47.175 ms (5 rows) time:47.725 ms