Postgres Pro
Downloads
Home   >   mailing lists

Re: Hash joins vs small-integer join values - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Hash joins vs small-integer join values
Date
Msg-id 16362.1180670455@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hash joins vs small-integer join values  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Tree view 
Josh Berkus <josh@agliodbs.com> writes:
> Tom,
>> The problem is that this is not a back-patchable
>> answer, because changing the hash functions would corrupt existing hash
>> indexes.  

> Does anyone *use* hash indexes?

We get bug reports on 'em, so yes ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Hash joins vs small-integer join values
Next
From: Michael Paesold
Date:
Subject: Re: Postmaster startup messages