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

From: "Dan Langille" <dan(at)langille(dot)org>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
Subject: Re: What kind of index to use for many rows with few unique
Date: 2002-12-02 23:23:02
Message-ID: 3DEBA506.20196.F87BE177@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 2 Dec 2002 at 15:15, Joe Conway wrote:

> 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?

FWIW, partial indexes didn't help for my distributions. But btrees
were satisfactory.
--
Dan Langille : http://www.langille.org/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-12-03 05:51:45 Re: pg_restore error: function plpgsql_call_handler already exists with same argument types
Previous Message Dan Langille 2002-12-02 23:15:40 Re: What kind of index to use for many rows with few unique values?