Hello,
I get success, with my hyphotetic sample on big table (100000 rec) Bitmap
index scan is really usefull.
I tested select count(*) from foo where
v IN (11,11,23,11,11,11,11,11,22,71,11)
Some notes.
1. with bitmap index scan 7.16 ms
2. without bis 165.731 ms (seq. scan) !!!!
3. list of constant contains equals values. Is possible remove it?
explain analyze select count(*) from foo
where v in (11,11,11,12)
Regards
Pavel Stehule
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
