Optimizing single-table queries
Consider all possible plans
Combine index scans
Plan:
Bitmap Heap Scan on test2 (cost=8.87..20.71 rows=3 width=12)
Recheck Cond: ((major = 1) OR (minor = '8'::double precision))
-> BitmapOr (cost=8.87..8.87 rows=3 width=0)
-> Bitmap Index Scan on pk_test2 (cost=0.00..4.43 rows=1 width=0)
Index Cond: (major = 1)
-> Bitmap Index Scan on minor_rand (cost=0.00..4.44 rows=2 width=0)
Index Cond: (minor = '8'::double precision)
|