Index for low selectivity field

From: Robert James <srobertjames(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Index for low selectivity field
Date: 2012-02-15 14:16:06
Message-ID: CAGYyBgjsSoFsRraAietXs3Oedop0ShEmo4dDz7hWPE7nOoX26w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2012-02-15 14:20:06 Memory tuning Postgres
Previous Message Robert James 2012-02-15 14:14:34 Rules of Thumb for Autovaccum