I overlooked the fact even in the bitmap index scan loose mode, the recheck is still executed before the qual, so bitmap index scan is OK in this case.
Sort
Output: oid, relname
Sort Key: pg_class.relname
-> Bitmap Heap Scan on pg_catalog.pg_class
Output: oid, relname
Recheck Cond: (pg_class.relnamespace = '28601'::oid)
Filter: (has_table_privilege(pg_class.oid, 'SELECT'::text) AND
(pg_class.relkind = ANY ('{r,m,v}'::"char"[])))
-> Bitmap Index Scan on pg_class_relname_nsp_index
Index Cond: (pg_class.relnamespace = '28601'::oid)
v2 attached.
--
Best Regards
Andy Fan
v2-0001-Avoid-a-potential-unstable-testcase.patch
Description: Binary data
