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

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

On 2 Dec 2002 at 17:10, David F. Skoll wrote:

> I've heard that a btree index performs badly in this situation.

As another poster has shown, it should be OK. I recently dealt with
distributions simlar to your example.

> Is a hash index appropriate? I've heard bad things about hash
> indexes in PostgreSQL.

No, don't use them. I didn't get any performance increase out of
them. Does your experience show poor btree results?
--
Dan Langille : http://www.langille.org/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dan Langille 2002-12-02 23:23:02 Re: What kind of index to use for many rows with few unique
Previous Message Joe Conway 2002-12-02 23:15:08 Re: What kind of index to use for many rows with few unique