Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50934=pgsql-performance-ar@postgresql.org>)
 id 1VqJtI-0001ig-GH
 for pgsql-performance@arkaria.postgresql.org; Tue, 10 Dec 2013 09:46:08 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50934=pgsql-performance-ar@postgresql.org>)
 id 1VqJtH-00057p-V7
 for pgsql-performance@arkaria.postgresql.org; Tue, 10 Dec 2013 09:46:08 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <mspasic@openlinksw.com>) id 1VqJtG-00057i-RW
 for pgsql-performance@postgresql.org; Tue, 10 Dec 2013 09:46:06 +0000
Received: from mail.openlinksw.com ([63.119.36.38])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <mspasic@openlinksw.com>) id 1VqJtC-00073a-Tj
 for pgsql-performance@postgresql.org; Tue, 10 Dec 2013 09:46:06 +0000
Received: from localhost ([127.0.0.1] helo=mail.openlinksw.com)
 by mail.openlinksw.com with esmtp (Exim 4.74)
 (envelope-from <mspasic@openlinksw.com>) id 1VqJt9-0000Hy-W3
 for pgsql-performance@postgresql.org; Tue, 10 Dec 2013 04:46:00 -0500
Received: from 79.101.70.18 (SquirrelMail authenticated user mspasic)
 by mail.openlinksw.com with HTTP;
 Tue, 10 Dec 2013 04:45:59 -0500 (EST)
Message-ID: <55000.79.101.70.18.1386668759.squirrel@mail.openlinksw.com>
Date: Tue, 10 Dec 2013 04:45:59 -0500 (EST)
Subject: Hash join
From: mspasic@openlinksw.com
To: pgsql-performance@postgresql.org
User-Agent: SquirrelMail/1.4.8-21.el5.centos
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-Pg-Spam-Score: 0.6 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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



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