[HACKERS] Force optimizer to use hash/nl/merge join?

[Zhan Li]

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

Re: [HACKERS] Force optimizer to use hash/nl/merge join?

[Amit Kapila]

On Mon, Nov 18, 2013 at 7:58 PM, Zhan Li zhanl...@gmail.com wrote:
 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.

PostgreSQL doesn't have join hints.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers