"Jim C. Nasby" <jnasby@xxxxxxxxxxxxx> 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