Postgres Pro
Downloads
Home   >   mailing lists

Re: Putting an INDEX on a boolean field? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Putting an INDEX on a boolean field?
Date
Msg-id 15887.1118983309@sss.pgh.pa.us
Whole thread Raw
In response to Putting an INDEX on a boolean field?  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: Putting an INDEX on a boolean field?  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-sql
Tree view 
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> Does that make sense?  Would it ever get used?

It could get used if one of the two values is far less frequent than the
other.  Personally I'd think about a partial index instead ...
        regards, tom lane

pgsql-sql by date:

Previous
From: David Dick
Date:
Subject: Re: Putting an INDEX on a boolean field?
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Putting an INDEX on a boolean field?