Re: Optimising a two column OR check
MichaelDBA <[email protected]> Sat, 12 Oct 2019 11:45:45 -0400
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
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 <[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. >> > > >