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
In response to
pgsql-performance by date
|Next:||From: Greg Stark||Date: 2004-07-29 17:57:55|
|Subject: Re: best way to fetch next/prev record based on index|
|Previous:||From: Merlin Moncure||Date: 2004-07-29 16:48:51|
|Subject: Re: best way to fetch next/prev record based on index |