Home > mailing lists

index over boolean fields? - Mailing list pgsql-novice

From
Subject	index over boolean fields?
Date	January 5, 2006 19:18:52
Msg-id	0a3a01c61235$32a0e650$0201a8c0@iwing Whole thread Raw
Responses	Re: index over boolean fields? (Jaime Casanova <systemguards@gmail.com>)
List	pgsql-novice

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

From: "Kevin Crenshaw"
Date: 05 January 2006, 19:10:12
Subject: Re: Best Type to use

From: Jaime Casanova
Date: 05 January 2006, 19:23:08
Subject: Re: index over boolean fields?