Re: Hash index - Mailing list pgsql-admin

From Tom Lane
Subject Re: Hash index
Date
Msg-id 24391.1125433203@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hash index  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Hash index  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> So does that mean a hash index could (theoretically) improve the
> performance of a hash join or hash aggregation?

I don't think so --- the whole point of a hash is to do your matching
in-memory, rather than jumping all over the disk for it ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Hash index
Next
From: Scott Marlowe
Date:
Subject: Re: Hash index