Postgres Pro
Downloads
Home   >   mailing lists

Re: What kind of index to use for many rows with few unique - Mailing list pgsql-admin

From Joe Conway
Subject Re: What kind of index to use for many rows with few unique
Date
Msg-id 3DEBE97C.3090304@joeconway.com
Whole thread Raw
In response to Re: What kind of index to use for many rows with few unique  ("David F. Skoll" <dfs@roaringpenguin.com>)
Responses Re: What kind of index to use for many rows with few unique  ("Dan Langille" <dan@langille.org>)
List pgsql-admin
Tree view 
David F. Skoll wrote:
> No, I'm sure a btree will work.  However, won't the index be
> inefficient (i.e., very flat) if there are many entries with the same
> value?  Or is this not a problem?
>

If you're concerned, why not try a partial index?

Joe

pgsql-admin by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: What kind of index to use for many rows with few unique values?
Next
From: "Dan Langille"
Date:
Subject: Re: What kind of index to use for many rows with few unique