Re: Merge Join vs Nested Loop - Mailing list pgsql-performance

From Tobias Brox
Subject Re: Merge Join vs Nested Loop
Date
Msg-id 20060927153619.GG17834@oppetid.no
Whole thread Raw
In response to Merge Join vs Nested Loop  (Tobias Brox <tobias@nordicbet.com>)
Responses Re: Merge Join vs Nested Loop  (Tobias Brox <tobias@nordicbet.com>)
List pgsql-performance
[Scott Marlowe - Wed at 10:31:35AM -0500]
> And remember, you can always change any of those settings in session for
> just this one query to force the planner to make the right decision.

sure ... I could identify the most problematic queries, and hack up the
software application to modify the config settings for those exact
queries ... but it's a very ugly solution. :-)  Particularly if Tom Lane
is correct saying the preferance of merge join instead of nested loop is
indeed a bug.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Merge Join vs Nested Loop
Next
From: "Dave Dutcher"
Date:
Subject: Re: Forcing the use of particular execution plans