Postgres Pro
Downloads
Home   >   mailing lists

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

From MichaelDBA
Subject Re: Optimising a two column OR check
Date
Msg-id 0517fa14-6a74-bcec-0655-9e240618c46f@sqlexec.com
Whole thread Raw
In response to Re: Optimising a two column OR check  (MichaelDBA <MichaelDBA@sqlexec.com>)
List pgsql-performance
Tree view
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  <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.





pgsql-performance by date:

Previous
From: MichaelDBA
Date:
Subject: Re: Optimising a two column OR check
Next
From: Andrew Gierth
Date:
Subject: Re: Optimising a two column OR check