index over boolean fields?

From: <me(at)alternize(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: index over boolean fields?
Date: 2006-01-05 20:18:31
Message-ID: 0a3a01c61235$32a0e650$0201a8c0@iwing
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jaime Casanova 2006-01-05 20:23:04 Re: index over boolean fields?
Previous Message Kevin Crenshaw 2006-01-05 20:10:04 Re: Best Type to use