Stan Bielski <bielski(at)ece(dot)cmu(dot)edu> writes:
> I having a great deal of difficulty getting postgres to do a hash join.
> Even if I disable nestloop and mergejoin in postgres.conf, the optimizer
> still refuses to select hash join.
Are you sure the join condition is hashjoinable? You didn't say
anything about the datatypes involved ...
If it is, the other possibility is that you need to increase sort_mem
to accommodate the hash table.
regards, tom lane