Re: Optimising a two column OR check

Andrew Gierth <[email protected]> Sat, 12 Oct 2019 16:33:37 +0100
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <[email protected]>
>>>>> "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.

-- 
Andrew (irc:RhodiumToad)