Postgres Pro
Downloads
Home   >   mailing lists

Hash join - Mailing list pgsql-performance

From mspasic@openlinksw.com
Subject Hash join
Date
Msg-id 55000.79.101.70.18.1386668759.squirrel@mail.openlinksw.com
Whole thread Raw
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Recommendations for partitioning?
Next
From: jacket41142
Date:
Subject: select count(distinct ...) is slower than select distinct in about 5x