Postgres Pro
Downloads
Home   >   mailing lists

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

From Marc G. Fournier
Subject Re: Putting an INDEX on a boolean field?
Date
Msg-id 20050617020039.P90456@ganymede.hub.org
Whole thread Raw
In response to Re: Putting an INDEX on a boolean field?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Putting an INDEX on a boolean field?
List pgsql-sql
Tree view 
On Fri, 17 Jun 2005, Tom Lane wrote:

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

Hrmmmm, hadn't thought of that ... wouldn't you have to build two indexes 
(one for true, one for false) for this to be completely effective?  unless 
you know all your queries are going to search for one, but not the other?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Putting an INDEX on a boolean field?
Next
From: Jaime Casanova
Date:
Subject: Re: Putting an INDEX on a boolean field?