Stan Bielski <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to