Re: bitmap heap scan exact/lossy blocks and row removal

Augusto Callejas writes: > I created a GIN index on the following relation and ran an EXPLAIN query on > a query, and noticed that despite all heap blocks being exact, that the > outermost bitmap heap scan removed 62 rows after recheck. My understanding > (mainly from > https://paquier.xyz/postgre

bitmap heap scan exact/lossy blocks and row removal

I created a GIN index on the following relation and ran an EXPLAIN query on a query, and noticed that despite all heap blocks being exact, that the outermost bitmap heap scan removed 62 rows after recheck. My understanding (mainly from https://paquier.xyz/postgresql-2/postgres-9-4-feature-highlight