Re: Optimising a two column OR check - Mailing list pgsql-performance

Nope, vacuumed it and still got the bitmap index scans.

Andrew Gierth wrote on 10/12/2019 11:33 AM:
>>>>>> "MichaelDBA" == MichaelDBA  <MichaelDBA@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.
>