Force optimizer to use hash/nl/merge join?

From: Zhan Li <zhanli89(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Force optimizer to use hash/nl/merge join?
Date: 2013-11-18 14:28:17
Message-ID: CANp-BfYq43w3CAQfXeZx3KbEdTxAgG9wcto+M=9S_pG7qxoz5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2013-11-18 14:31:23 Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])
Previous Message Sev Zaslavsky 2013-11-18 14:15:39 Re: LISTEN / NOTIFY enhancement request for Postgresql