Subject: Re: Optimising a two column OR check
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: Jeff Janes <jeff.janes@gmail.com>, Justin Pryzby <pryzby@telsasoft.com>,
 Ivan Voras <ivoras@gmail.com>,
 postgres performance list <pgsql-performance@postgresql.org>
References: 
 <CAF-QHFXQduEoX=ADZh2QYECLdcM1zOuY6=K0cE_DBjhdH3v+WA@mail.gmail.com>
 <20191012144336.GA4475@telsasoft.com>
 <CAMkU=1w1F0t7c78mJMF7DdBbk50aGy3-AROGzcbdPrS0ApmGAA@mail.gmail.com>
 <a0ab3bae-6a5d-b2ea-b3a0-cbcff72f394f@sqlexec.com>
 <87y2xqvv1x.fsf@news-spur.riddles.org.uk>
From: MichaelDBA <MichaelDBA@sqlexec.com>
Message-ID: <25d9306a-d0e9-ed82-3128-bff469f09aed@sqlexec.com>
Date: Sat, 12 Oct 2019 11:35:22 -0400
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 PostboxApp/7.0.5.2
MIME-Version: 1.0
In-Reply-To: <87y2xqvv1x.fsf@news-spur.riddles.org.uk>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk

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.
>