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

From Josh Berkus
Subject Re: Hash joins vs small-integer join values
Date
Msg-id 465F96E5.2010505@agliodbs.com
Whole thread Raw
In response to Hash joins vs small-integer join values  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Hash joins vs small-integer join values  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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?

> Comments, better ideas?

I was just talking to Luke today and he said they had a considerable 
amount of cleanup on hash join they were planning to contribute for 8.4.   Luke?


--Josh


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Autovacuum versus rolled-back transactions
Next
From: Gregory Stark
Date:
Subject: Re: Hash joins vs small-integer join values