Re: index over boolean fields?

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: "me(at)alternize(dot)com" <me(at)alternize(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: index over boolean fields?
Date: 2006-01-05 20:23:04
Message-ID: c2d9e70e0601051223y31b6b723kd7107128e150d6f4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 1/5/06, me(at)alternize(dot)com <me(at)alternize(dot)com> wrote:
> hi list
>
> does an index over a boolean field make sense performance-wise? 1/3 of all
> records are set to true... what index type if any would be best?
>
> thanks,
> thomas

only if you create a partial index, using the expression that will
contain the smallest fraction of values...

but for a third part of the records i don't think it will be a win...

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ketema Harris 2006-01-05 20:27:24 Re: Best Type to use
Previous Message me 2006-01-05 20:18:31 index over boolean fields?