Perhaps the fix by Alexander Kuzmenkov in V11 added this VM
consideration for having a preference of bitmap index scan over an index
only scan. Looks like I'm goin' down the rabbit hole...
Regards,
Michael Vitale
MichaelDBA wrote on 10/12/2019 11:35 AM:
Nope, vacuumed it and still got the bitmap index scans.
Andrew Gierth wrote on 10/12/2019 11:33 AM:
"MichaelDBA" == MichaelDBA <michael...@sqlexec.com> writes:
MichaelDBA> BTW, to Andrew, the UNION ALL alternative still results in
MichaelDBA> bitmap index scans from my testing.
You probably forgot to vacuum the table.
