Re: Optimising a two column OR check

MichaelDBA <[email protected]> Sat, 12 Oct 2019 11:35:22 -0400

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<[email protected]>

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

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