Postgres Pro
Downloads
Home   >   mailing lists

Index for low selectivity field - Mailing list pgsql-general

From Robert James
Subject Index for low selectivity field
Date
Msg-id CAGYyBgjsSoFsRraAietXs3Oedop0ShEmo4dDz7hWPE7nOoX26w@mail.gmail.com
Whole thread Raw
Responses Re: Index for low selectivity field
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Robert James
Date:
Subject: Rules of Thumb for Autovaccum
Next
From: Robert James
Date:
Subject: Memory tuning Postgres