Force optimizer to use hash/nl/merge join? - Mailing list pgsql-hackers

From Zhan Li
Subject Force optimizer to use hash/nl/merge join?
Date
Msg-id CANp-BfYq43w3CAQfXeZx3KbEdTxAgG9wcto+M=9S_pG7qxoz5g@mail.gmail.com
Whole thread Raw
Responses Re: Force optimizer to use hash/nl/merge join?  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
Hi All,

Is there any way to force the optimizer to use a specific join operator? For example, in SQL Server, I can do this way 

select * from (A inner hash join B on A.a = B.b) inner loop join C on A.a = C.c

I did some search but didn't find PostgreSQL had similar join hints except for enable_* setting which doesn't help in my case.

Best Regards,
Zhan

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: additional json functionality
Next
From: Amit Kapila
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])