Re: Why hash indexes suck

From: Jeff Davis <jdavis-pgsql(at)empires(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Why hash indexes suck
Date: 2004-06-05 22:30:34
Message-ID: 1086474634.13110.199.camel@jeff
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Sat, 2004-06-05 at 13:31, Tom Lane wrote:
> Only if you want to require a hash opclass to supply ordering operators,
> which sort of defeats the purpose I think. Hash is only supposed to
> need equality not ordering.

Is it possible to assume some kind of ordering (i.e. strcmp() the binary
data of the type) as long as it's consistent?

Regards,
Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2004-06-05 23:03:08 Re: How to find out who is calling the function
Previous Message Martijn van Oosterhout 2004-06-05 22:22:19 Re: pg_class could not be found

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-06 00:15:54 Re: Why hash indexes suck
Previous Message Andrew Dunstan 2004-06-05 22:27:05 Re: Official Freeze Date for 7.5: July 1st, 2004