Re: enforcing a join type - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: enforcing a join type
Date
Msg-id 41118D37.4050802@familyhealth.com.au
Whole thread Raw
In response to enforcing a join type  ("Hicham G. Elmongui" <elmongui@cs.purdue.edu>)
List pgsql-hackers
> If I want the planner/optimizer to always choose merge join when it needs to
> join relations. How can I do it ?

You can't, unless in your transaction you set enable_nestloop, 
enable_seqscan, etc. all to off except for the join type you want.

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Bug in ALTER COLUMN/TYPE
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: enforcing a join type