Re: What kind of index to use for many rows with few unique

From: Joe Conway <mail(at)joeconway(dot)com>
To: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
Cc: Joel Burton <joel(at)joelburton(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: What kind of index to use for many rows with few unique
Date: 2002-12-02 23:15:08
Message-ID: 3DEBE97C.3090304@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dan Langille 2002-12-02 23:15:40 Re: What kind of index to use for many rows with few unique values?
Previous Message David F. Skoll 2002-12-02 23:14:49 Re: What kind of index to use for many rows with few unique