Thread: Query Planner

On Mon, Feb 26, 2007 at 05:19:05PM +0530, Gauri Kanekar wrote:
> I have a Query. So when i do explain analyse on it , it shows me many Hash
> Joins.
> So is it possible to indicate the Query Planner not to consider Hash Join.

set enable_hashjoin = false;

This is very often the wrong solution, though. If hash join is indeed slower
than merge join, the planner should have guessed so, and it would be better
to find out why the planner guessed wrong, and correct it somehow.

/* Steinar */
--
Homepage: http://www.sesse.net/