Re: Planner question - "bit" data types

[Karl Denninger <karl@xxxxxxxxxxxxx>]

Tom Lane wrote:

Karl Denninger <karl@xxxxxxxxxxxxx> writes:
  

That doesn't help in this case as the returned set will typically be
quite large, with the condition typically being valid on anywhere from
10-80% of the returned tuples.
    

In that case you'd be wasting your time to get it to use an index
for the condition anyway.  Maybe you need to take a step back and
look at the query as a whole rather than focus on this particular
condition.

			regards, tom lane

  

The query, sans this condition, is extremely fast and contains a LOT of other conditions (none of which cause trouble.)

It is only attempting to filter the returned tuples on the permission bit(s) involved that cause trouble.

-- Karl

begin:vcard
fn:Karl Denninger
n:Denninger;Karl
email;internet:karl@xxxxxxxxxxxxx
x-mozilla-html:TRUE
version:2.1
end:vcard

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance