Re: is there any way we can push join predicate into inner table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 挨踢人 <2363541664(at)qq(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: is there any way we can push join predicate into inner table
Date: 2015-08-31 14:36:01
Message-ID: 5676.1441031761@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"=?gb18030?B?sKTM38jL?=" <2363541664(at)qq(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message twoflower 2015-08-31 16:09:11 Query > 1000× slowdown after adding datetime comparison
Previous Message 挨踢人 2015-08-31 13:51:54 is there any way we can push join predicate into inner table