From: Tom Lane <tgl@sss.pgh.pa.us>
To: 挨踢人 <2363541664@qq.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: is there any way we can push join predicate into inner table
Date: Mon, 31 Aug 2015 10:36:01 -0400
Message-ID: <5676.1441031761@sss.pgh.pa.us> (raw)
In-Reply-To: <tencent_38B35CB76BAA9EC85B7BCF20@qq.com>
References: <tencent_38B35CB76BAA9EC85B7BCF20@qq.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
"=?gb18030?B?sKTM38jL?=" <2363541664@qq.com> writes:
> So, the question is, is there any way we can push join predicate into inner table ( we can disable merge join and hash join to get NL Join, but join predicate is not able to push into inner table )?
You probably need to turn on use_remote_estimate; postgres_fdw won't
consider parameterized paths without that, because it has no way to
compare costs.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, 2363541664@qq.com
Subject: Re: is there any way we can push join predicate into inner table
In-Reply-To: <5676.1441031761@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox