Hash join

From: mspasic(at)openlinksw(dot)com
To: pgsql-performance(at)postgresql(dot)org
Subject: Hash join
Date: 2013-12-10 09:45:59
Message-ID: 55000.79.101.70.18.1386668759.squirrel@mail.openlinksw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello everyone,

I'm looking for a way to specify join order in SQL query. Actually, the
optimizer has chosen a plan with hash join of 2 tables, but I would like
to know if there is a way to force it to use hash join, but with replaced
tables on build phase and probe phase?

Thank you,
Mirko Spasic

Browse pgsql-performance by date

  From Date Subject
Next Message jacket41142 2013-12-10 17:28:22 select count(distinct ...) is slower than select distinct in about 5x
Previous Message Scott Marlowe 2013-12-07 20:37:12 Re: Recommendations for partitioning?