Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group