Re: Hash joins vs small-integer join values

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org, Joseph Shraibman <jks(at)selectacast(dot)net>, Luke Lonergan <llonergan(at)greenplum(dot)com>
Subject: Re: Hash joins vs small-integer join values
Date: 2007-06-01 03:47:49
Message-ID: 465F96E5.2010505@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-06-01 03:51:43 Re: Hash joins vs small-integer join values
Previous Message Andrew Dunstan 2007-06-01 03:39:30 Re: [HACKERS] like/ilike improvements