Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Gierth
Subject Re: Optimising a two column OR check
Date
Msg-id 87y2xqvv1x.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Optimising a two column OR check  (MichaelDBA <MichaelDBA@sqlexec.com>)
Responses Re: Optimising a two column OR check  (MichaelDBA <MichaelDBA@sqlexec.com>)
List pgsql-performance
Tree view 
>>>>> "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.

-- 
Andrew (irc:RhodiumToad)

pgsql-performance by date:

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