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
---(end of broadcast)-
I didn't mean about doing this from a front end. I want to disable
nested_loop and hash_join from the backend.
I tried to set the variables (enable_nestloop and enable_hashjoin) in
costsize.c, but this didn't do it.
Turn them off in your postgresql.conf then.
Chris
---(end o
is is still the wrong place for this question.
--h
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 6:42 PM
To: Hicham G. Elmongui
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [HACKERS] enforcing a join type
As this is not really
Original Message-
> From: Scott Marlowe [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 04, 2004 5:41 PM
> To: Hicham G. Elmongui
> Cc: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] enforcing a join type
>
> On Wed, 2004-08-04 at 14:53, Hicham G. Elmongui wrote:
> >
lto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 5:41 PM
To: Hicham G. Elmongui
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] enforcing a join type
On Wed, 2004-08-04 at 14:53, Hicham G. Elmongui wrote:
> Hi,
> If I want the planner/optimizer to always choose merge join when it needs
to
On Wed, 2004-08-04 at 14:53, Hicham G. Elmongui wrote:
> Hi,
> If I want the planner/optimizer to always choose merge join when it needs to
> join relations. How can I do it ?
>From my past experience, I'd guess what you're really trying to do is
STOP the planner from choosing a nested_loop join,
