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

From Tobias Brox
Subject Re: Merge Join vs Nested Loop
Date
Msg-id 20060927150512.GE17834@oppetid.no
Whole thread Raw
In response to Re: Merge Join vs Nested Loop  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: Merge Join vs Nested Loop  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-performance
[Scott Marlowe - Wed at 09:58:30AM -0500]
> Have you tried chaning the cpu_* cost options to see how they affect
> merge versus nested loop?

As said in the original post, increasing any of them shifts the planner
towards nested loops instead of merge_join.  I didn't check which one of
the cost constants made the most impact.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Merge Join vs Nested Loop
Next
From: Scott Marlowe
Date:
Subject: Re: Merge Join vs Nested Loop