Re: [GENERAL] Index for low selectivity field

2012-02-15 Thread Andy Colson
On 2/15/2012 8:16 AM, Robert James wrote: A table has a column "obj_type" which has very low selectivity (let's say 5 choices, with the top choice making up 50% of records). Is there any sense in indexing that column? B-trees won't be that useful, and the docs discourage other index types/ It

[GENERAL] Index for low selectivity field

2012-02-15 Thread Robert James
A table has a column "obj_type" which has very low selectivity (let's say 5 choices, with the top choice making up 50% of records). Is there any sense in indexing that column? B-trees won't be that useful, and the docs discourage other index types/ -- Sent via pgsql-general mailing list (pgsql-g