Gregory Stark wrote:
Mohamed <mohamed5432154321@xxxxxxxxx> writes:
I want to match against a boolean field, that is, only true or false is
possible. I am thinking Btree but not sure.. correct?
No index is going to be particularly effective for boolean columns unless
they're very heavily skewed. You might find it useful to build separate
partial indexes on other keys for each value though.
Gregory,
Just for the edification of the masses, can you show an example that
illustrates your point about partial indexes?
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
